Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Update table based on the resultset of a SQL Statement RE: SSIS Update table based on the resultset of a SQL Statement

  • February 24, 2014 at 5:15 pm

    #1691741

    I don't have a set of screen shots handy, but these are my normal steps:

    1) create a SSIS variable

    2) use a SQL task to query they first database

    3) use the results tab of the SQL task to put the output into the variable

    4) create the second task (sql command, flow etc) with a ? as the marker for the variable

    5) use the parameter tab to bind in the variable