Home Forums Data Warehousing Data Transformation Services (DTS) DTS - How to update records using DTS RE: DTS - How to update records using DTS
conrad coetzee
SSC Enthusiast
Points: 112
More actions
July 16, 2004 at 7:36 am
#514837
If I understand you correctly:
Use the ‘Transform data task’ to insert new rows and an update query in an ‘Execute SQL Task’ to update existing rows.
Create a DTS package with ‘Execute SQL Task’ and ‘Transform data task’