Post reply

Passing a parameter value to Stored Proc in SSIS 2008

  • June 2, 2016 at 12:52 pm

    #308157

    This topic is probably beating a dead horse with a stick, but all I need to know is about passing a parameter value to a stored procedure for SSIS use. So I have a simple stored proc that will use one parameter - @BatchID. What we need to do is query a database table that holds a text field and save that text as a text file, however it needs to be filtered by the batch number(s). How can I feed SSIS those batch number(s) or have an end user feed the batch number? Being a programmer I probably can write a quick UI and do the actual programming, but I usually use SSIS in these cases as it is quick.

    Thanks for any information.

  • June 2, 2016 at 1:02 pm

    #1882914

    Use the Parameters Mapping tab and use a question mark (?) where the parameter goes. This is if you're using an OLEDB connection.

    Further information:

    https://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 2, 2016 at 1:15 pm

    #1882924

    Thanks for the link. I will check this

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

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