Post reply

Two text files from one OleDB Source

  • August 10, 2011 at 12:37 am

    #245948

    Hello All,

    I have a OleDB Source which executes a stored procedure. The Stored procedure returns a rowset as well as a output parameter.

    Now I need to generate two text files

    1. With the rowset returned from SP.

    2. With the Output parameter from the same SP. Is that possible ?

    If possible how to do that

  • August 11, 2011 at 10:11 am

    #1367428

    You could use a TSQL task to execute the procedure and return the output parameter into a table. Then have a seperate data flow which copies the data from the table into the second file.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

  • August 16, 2011 at 9:40 am

    #1369147

    Hi Pals,

    Finally done it by creating Script Task.

Viewing 3 posts - 1 through 2 (of 2 total)

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