Post reply

How to I get the value of a variable after the package is completed ?

  • February 26, 2010 at 11:16 am

    #221043

    Hopefully this is a simple question, but so far I cannot find an answer on google.

    I am running a ssis package via a stored procedure that shells out to the operating system and runs the package via dtexec. This all works fine.

    One of the tasks in the package inserts a row into a table. This table has an identity column. I have this value in a variable and use it just fine in subsequent tasks in the package.

    Now I need to return the value of this variable back to the stored procedure where this process started. So, is there a way that I can get the value of this variable after the package is complete ?

    Thanks,

    Bill, Charlotte NC

  • February 26, 2010 at 11:33 am

    #1125748

    do you want to use the variable and pass it to the stored procedure on next execution???,.. i guess the only way would be store the value somewhere and then use it.. because once the package execution completes you will not be able to retrieve the value of the variables... They are similar to variables in SQL server

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

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