Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS insert and update

Author  Topic 

Yak Posting Veteran

79 Posts

Posted - 2015-04-30 : 16:56:12
Hello all,
I have a SSIS package that starts with a text file. It is imported to SQL Server to a staging table.

Here is the part where I am stuck: After data is loaded to staging table, I need to run an update statement. I tried adding an execute sql task in the control flow, but I keep getting messages about the property in the resultset being incorrect or missing. I have tried various options but am obviously missing something.

Is there a good tutorial out there that will visually show how to do an update? My update statement has no parameters, the set is based on the data in the staged table.

Thank you!

- Advertisement -