Asked 6 years, 11 months ago. Active 6 years, 11 months ago. Viewed 14k times. I was asked to make this translation without modifying the sql query. If you need to know more to give help, please ask, but be polite.
Even though it's in a dataflow task. Just a heads up this will not result in a set based update. It will be row by row and will be incredibly slow. You're better off dumping that information into a staging table and then running a update statement in an Execute SQL Task.
Not possible for for, I can not create any new table in the data base, that is why I ask. If your question has been answered, can you please close it by clicking the check-mark next to the answer? Add a comment. Active Oldest Votes. Tab Alleman Tab Alleman Answered by:. Archived Forums. Sign in to vote. Friday, September 24, PM. Talk to me now on. Monday, September 27, PM. Was there any error, the code looks correct. Arthur My Blog. Source table used in this example is Department table from AdventureWorks sample database which you can download online for free.
That part is required because Merge Join transform require sorted sources as input. Name this component as Source Table. In this example source and destination has same table name but are in different databases. So we use same script as step 1 for this one as well.
Name this component as Destination Table. Then change the SortKeyPosition to 1. Set Source Table as left and Destination Table as right input of this transformation. Select all columns from Source and Destination tables in the merge join transform, and rename them as picture below shows add Source or Destination prefix to each column.
Also rename default output as existing records and screenshot below shows. Expressions used in this sample are very easy and simply find record changes. For example expression below:.
0コメント