Update existing columns

I need to create an SSIS package that updates columns in a table from columns in another database where the keys match. What's the best way to do this

Answer this question

Update existing columns

Jerry Doebler
Jamie,

Isn't the OLE DB command is pretty slow and resource consuming while updating columns I've tried this in one of my data flow transformations and it took a while to update few records in big table.

Any other better way to do it

Thanks.
DreDay
That was enough to get me started. Thanks.
Wallace_

As with most things in SSIS there is more than one way of achieving this but the default method here is to build a data flow that extracts data from the "other" database, then use an OLE DB Command transform to do the update.

-Jamie
Update existing columns

Answer this question

Update existing columns

Hot Topic

SQL Server

Update existing columns

Update existing columns

Jerry Doebler

DreDay

Wallace_