Post reply

Using Parameters/ Variables in SSIS

  • June 1, 2010 at 6:40 pm

    #222149

    I have a need to pass values via parameters/ variables throughout my SSIS package. Unfortunatly I have never needed to do it before and do not know where to begin.

    My Example:

    I need to query a database to return a value such as rowcount, then take this value and pass it to another task later on in the package that will run a stored procedure using the value as a parameter.

    Any direction on good "how-to"s or simple explainations would be greatly appreciated.

    Thank You In Advance.

    J.T.

  • June 1, 2010 at 7:20 pm

    #1175064

    Store the result from the first query into a variable that can be used by the second query.

    See this link for more about doing this in an Execute SQL Task.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 2, 2010 at 12:21 am

    This was removed by the editor as SPAM

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

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