Need to generate 2 text files from 2 different stored proces

  • 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

  • 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