Post reply

Table Variable/DTS question

  • June 26, 2007 at 5:57 am

    #117578

    I have a dts that calls a stored proc which creates & populates several table variables.

    I want to be able to use the data within these tables to populate different worksheets within Excel all within the same DTS package.

    Is there a 'clean' way of doing this, or would it be more efficient to change the table variables to temp tables, use the data and then drop the tables once complete.

    Thanks

  • June 26, 2007 at 9:50 am

    #715290

    Table variables are automatically cleaned up at the end of the stored procedure that creates them so you're better off using real tables and dropping them when you're done using them in the package.

    Greg

    Greg

  • June 27, 2007 at 2:23 am

    #715455

    I hope temp tables can be used as they have the scope to exist till the connection closes but i have read somewhere in this forum a user stating that he was not able to use a temp table in a dts and that was causing him few problem and he had to move to a physical table.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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