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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply