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 |
|
Oliviaf2012
Starting Member
16 Posts |
 Posted - 2012-09-25 : 12:56:56
|
| I have a simple SSIS package that runs and SQL query and outputs the results to a csv file. What I want to do now is put multiple queries into the package and output the data into multiple files - how do I do this or do I have to create multiple packages. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-25 : 14:59:55
|
| You can have multiple data flow tasks in one SSIS package (in the data flow tab). You will need to create the appropriate source and destination connection managers and attach to the data flow tasks. Also see here: http://msdn.microsoft.com/en-us/library/ms141122.aspx |
 |
|
|
Oliviaf2012
Starting Member
16 Posts |
Posted - 2012-09-26 : 06:05:03
|
| Thanks Sunitabeck |
|
|
|
|
|
|
Multiple Queries in SSIS Package