Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SunnyDee
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! |
|
|
|
|
|
SSIS insert and update