Need to generate 2 text files from 2 different stored proces

• NLV

  SSChasing Mays

  Points: 654

  More actions

  September 7, 2011 at 3:04 am

  #390355

  Hi,

  I am developing SSIS package and I have to generate 2 fixed width text files to a configured location with 2 different stored procedures on same database in a single package.

  Can anyone suggest on this.

  Thanks

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  September 7, 2011 at 3:19 am

  #1377847

  create one package with a data flow that has Two data sources (your two procedures) an two destinations (your two files)

  or you could have two seperate data flows if the two procedures need to be sequentialy