Update table using SSIS
- by thursdaysgeek
I am trying to update a field in a table with data from another table, based on a common key. If it were in straight SQL, it would be something like:
Update EHSIT
set e.IDMSObjID = s.IDMSObjID
from EHSIT e, EHSIDMS s
where e.SITENUM = s.SITE_CODE
However, the two tables are not in the same database, so I'm trying to use SSIS to do the update. …