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 25, 2014 at 8:58 am

    #1691940

    EricEyster (2/25/2014)

    close.

    the statement from variable would be used if you have a script task that assembles the full query text. That is not the case here. Use "Direct Input" and paste the select into the SQLStatement block. It should look like

    select *

    from test

    where c1 = ?

    next, go to parameter mappings and add a new param, pick you variable and data type.

    I'm a bit confused (too much multitasking). In the Execute SQL task, I have Direct input, and the SQLStatement I need to grab the variable data. Would the example SQL you listed be in the OLE DB Source of the Data Flow or somewhere else?