Post reply

need to export multiple text file in same package

  • May 8, 2012 at 1:33 pm

    #257677

    Hello Friends

    I have a task, in that i have 7 different scripts. and i need to Export all result for that sql script in to Text files in same SSIS Package.

    So is it possible in same package so i need to run once and after execution it creates 7 different text files.

    If Possible then please reply me

    Thanks

  • May 8, 2012 at 1:47 pm

    #1484738

    Yes, this is quite possible.

  • May 8, 2012 at 1:50 pm

    #1484741

    so

    with using multiple Data Flow Task.

    we can export 7 different text files

    am i right?

  • May 8, 2012 at 1:55 pm

    #1484745

    Yep. I did it with 30 or so files.

  • May 8, 2012 at 1:56 pm

    #1484747

    Thanks Man

    Appreciate

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply