Post reply

Capture User variable from SSIS Execute SQL task

  • June 18, 2012 at 11:19 pm

    #263111

    Hi..

    I am using SSIS 2008. I have defined a variable in Pacakge scope ReqId with value 'Req123'. I need to capture the value 'Req123' in Execute SQL task.

    How can i acheive this?

  • June 19, 2012 at 7:57 am

    #1502862

    What do you want to do with the variable in your Execute SQL task? From the information you've given, it sounds as if you need to use an input parameter.

    John

  • June 21, 2012 at 3:13 am

    #1503825

    (1)double click on executeSQLtask

    (2)click Parameters Mapping tab in executeSQLtask

    (3)click on add button

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

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