Export query to two files

Question

Export query to two files

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

Just split the datastream into two datastreams by using the multicast component. That way you'll have two outputs. Connect each of them to the corresponding file.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 247183 More actions · Answer 2

Koen Verbeeck (1/26/2012)
Just split the datastream into two datastreams by using the multicast component. That way you'll have two outputs. Connect each of them to the corresponding file.

Or maybe you could add a file copy at the end of your package - use a file system task or script task to do this.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

Phil Parkin (1/26/2012)
Koen Verbeeck (1/26/2012)
Just split the datastream into two datastreams by using the multicast component. That way you'll have two outputs. Connect each of them to the corresponding file.
Or maybe you could add a file copy at the end of your package - use a file system task or script task to do this.

Hmmm, an even better solution!

It reduces network traffic and has less memory impact on the server that runs SSIS.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

rothj Hall of Fame Points: 3531 More actions · Answer 4

rothj

Hall of Fame

Points: 3531

January 26, 2012 at 6:01 am

#1438717

Great, thank you for the advice.