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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS insert and update
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SunnyDee
Yak Posting Veteran

79 Posts

Posted - 04/30/2015 :  16:56:12  Show Profile  Reply with Quote
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!
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000