SSIS Package

• Kris-155042

  Hall of Fame

  Points: 3460

  More actions

  March 29, 2016 at 4:58 pm

  #326136

  Hi,

  I have a SSIS package that runs a stored procedure and exports to CSV. There is a column called Staff. I want a new CSV file every time the data changes i.e.

  Staff01 First csv

  Staff01

  Staff01

  Staff02 Second csv

  Staff02

  Staff02

  Staff03 Third csv

  ---

  Thanks,

  Kris

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  March 30, 2016 at 3:20 pm

  #1868720

  Hi,

  Imho if there is constant number of Stuff's, you can use the Conditional Split to route data rows to different outputs

  Br.

  Mike