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 |
|
skybvi
Posting Yak Master
193 Posts |
 Posted - 2011-05-03 : 16:31:24
|
| Hi,In a SSIS package, I am getting the output to a table named query.Now, I want to transform the data or I should say I want to put t-sql code( many updates,joins) to the table named query and then put the results into anohter table.Which tool in SSIS i should use for doing this?Regards,SushantDBAWest Indies |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-03 : 17:24:00
|
| An sql task will do it. Just run the isert statement==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-05-06 : 10:53:45
|
| if you are in control flow you can use Execute sql task if you are in data flow task you can use Oledb command transformation with respective update or insert command.An sample can help us to provide you with better option. |
|
|
|
|
|
|
How to transform table results into anotehr