How can i make the data transformation in DTS to do an update instead of insert?

Question

How can i make the data transformation in DTS to do an update instead of insert?

CarlaAbanes

Right there with Babe

Points: 782
More actions
August 14, 2012 at 2:04 am

#260692

Hi guys,
this is the dilemma im in now. i have to create a DTS package that instead of doing the usual copy columns in data transformation, i need it to perform an update statement instead. Any ideas on how i should move forward with this??
appreciate for any replies..TIA
Cheers!
[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 1

I forgot most of my DTS skills but since you have not received any responses I'll make a general suggestion:

Instead of loading the data directly into your target table, load the data into a staging table using the current 'copy columns' method and then issue an UPDATE...JOIN to update your target table from the data in your staging table.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

pujain SSCrazy Points: 2903 More actions · Answer 2

why arent you using SSIS? you can easily do it using SSIS.

How can i make the data transformation in DTS to do an update instead of insert?

Cookies on SQLServerCentral