Post reply

Not able to map Parameters correctly in SSIS

  • December 21, 2009 at 3:13 am

    #137744

    All,

    I am a starter to SSIS. I used to work with DTS sometimes back and recently facing some weird issue with SSIS while trying to set a package variable using parameters from a SQL query. This really sounds weird as after too may tries I am not able to get any solution. Please check the snaps. 🙁

    Thanks in advance,

    Nikhil

  • December 21, 2009 at 3:20 am

    #1094642

    You only need to map the "Result Set'.

    Parameter mapping is for the input parameters for the query and your query does not accept any parameters it is a direct SQl statement that returns 2 columns and that you have mapped in the Result Set.

    Remove the Parameter Mapping and it should work.

    Let us now the result.

    -Vikas Bindra

  • December 21, 2009 at 4:27 am

    #1094670

    Thanks Vikas... It worked like charm.. I was under impression that if you are passing something to variable that is also a output variable for the execute task query.

    Anyways thanks again 🙂

    Thanks,

    Nikhil

  • December 21, 2009 at 6:00 am

    #1094691

    You are welcome..

    -Vikas Bindra

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

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