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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2008-02-26 : 09:13:40
|
| I have an update query, and I want to run it as part of a SSIS package.But to me creating these SSIS packages is looking abit like rocket science.I know how to create a simple import package and save it as a file. Then right-click and choose edit but then once inside Visual Studio it's all a bit confusing. Is there any tutorials out there that will show me how to edit my simple import package and turn it into an update package. |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2008-02-26 : 10:51:33
|
If anyone else is struggling with this. Its actually far simpler than I thought.You don't need any dataflow tasks and you only need one connection.All I did was to put a "Execute a SQL task" on the control flow. DOuble click on it and specify the connection and write the query. |
 |
|
|
|
|
|
Update query in a package