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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-04-24 : 10:20:58
|
| i want to make this query in SSIS (no Execute SQL Task):update a set a.name = a.name +'AA'from dbo.PART a inner join dbo.Products bon a.name = b.CODEwhere b.TYPE = '01'i make this steps:1. chosee OLE DB SORCE for PART and FOR ProductCd2.choose Sort for PART and FOR ProductCd3.conditional split from b.TYPE = '01'3.Merge Join between them4.Derived Columns for a.name +'AA'i dont know how to replace the column a.name? |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-04-24 : 11:04:05
|
| Any reason for not using an SQL task. This is so much easier doing it there. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-04-26 : 01:30:16
|
| i know it's much easier doing it ,the question if is it the right way? |
|
|
|
|
|
|
update-ssis