Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Export Column Specific

Author  Topic 

LiquidTobi
Starting Member

4 Posts

Posted - 2006-08-31 : 18:14:02
I need to move a table from one database to another, but the column layout is different, I am wondering how (in SQL Server 2000 Enterprise Manager) I can export a table and manually select which columns go where.

Registered Linux User #365191

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-31 : 18:24:23
Could you post both layouts so that we can help you with the code?

Tara Kizer
Go to Top of Page
   

- Advertisement -