Running the OLEDB Source concurrently.

• dhanasekar.palani

  SSC Eights!

  Points: 841

  More actions

  November 21, 2008 at 7:06 am

  #127892

  I created a ssis package,In the dataflow task i have a oledb source and a flat file destination. I have given the procedure in the oledb source,The procedure returns 1 billion rows which affects the performance.Is it possible to run two procedures(two oledb sources) concurrently and merge the output to the flat file?

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  November 21, 2008 at 7:39 am

  #901619

  Yes, there is a UNION ALL component that will merget together two identical data streams.

  Unfortunately, this is just as likely to hurt performance as it is to help, but you can certainly try it.