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:43 am

    #1691933

    Getting closer. I set ResultSet to Single row, and I was able to add the variable in the Result Set section. In the Data Flow (OLE DB SOurce) I put SQL command from variable in the Data access mode, and selected the variable in the Variable name drop-down. When I click Preview or OK, I get Error at Data Flow Task: Command text was not set for the command object.