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.
| Author |
Topic |
|
vravo
Starting Member
13 Posts |
 Posted - 2005-04-19 : 10:58:43
|
While I’m familiar with DTS and use it regularly I’m not sure if you can do this. Is there a way to export data to trough 1 DTS package or a Stored Procedure to multiple files with different export names... all will have different data. I put data into a table based on 4 categories... I would like to then export that data to 4 different files with the 4 different categories as file names... yes I can do this with four separate DTS packages but I'm looking for a more efficient way to do it...ThanksVin |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-04-19 : 12:14:47
|
Create 1 DTS with 4 different "file" connections, each with its own transformationAndyBeauty is in the eyes of the beerholder  |
 |
|
|
vravo
Starting Member
13 Posts |
Posted - 2005-04-19 : 17:43:46
|
| ohhh... didn't know you could do more then one.... I tried it and that worked perfect!!! ThanksVin |
|
|
|
|
|
|
DTS or Stored Proc Export to Different Files