Post reply

Need help to understand direction in Execute SQL task - Parameter mapping - Direction

  • September 30, 2013 at 4:17 pm

    #283334

    Go to Execute SQL task - Parameter mapping - Direction (It has 3 options - Input, Output, ReturnValue)

    What does this direction mean ?

    I saw a post here - https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets/

    which says

    Direction: Determines whether to pass a value into a parameter (input) or return a value through the parameter (output)

    But I did not understand this. What is meant by "return a value through the parameter (output)" ?

  • September 30, 2013 at 9:45 pm

    #1654768

    If you are using the stored proc to lookup a value and return that to your SSIS package, you can do this using an output variable in the stored proc - for this you would using the Output direction

  • October 1, 2013 at 1:00 am

    #1654781

    happycat59 (9/30/2013)

    If you are using the stored proc to lookup a value and return that to your SSIS package, you can do this using an output variable in the stored proc - for this you would using the Output direction

    +1

    Although I would rather use the resultset option to return values to SSIS instead of parameters.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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