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 multiple files from one Table

Author  Topic 

harrisw48
Starting Member

34 Posts

Posted - 2007-03-22 : 12:32:51
I have a specific code in a field and want to export several separate files from one table.

I need to do this within a DTS

How do I do it?

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-23 : 15:35:20
Same data to different files or Spread your data to muliple files?

If same data to multiple files then copy to one file then make the copy of the file using xp-cmshell command...


MohammedU
Go to Top of Page
   

- Advertisement -