Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS : DDQ : Determine rows to delete

Author  Topic 

punt
Starting Member

1 Post

Posted - 2004-09-17 : 09:10:56
a

DustinMichaels
Constraint Violating Yak Guru

464 Posts

Posted - 2004-09-17 : 09:19:34
Maybe you need to make some staging tables that would be used only in your dts package.

For example if you insert all of the rows of the source into a temporary staging table you could perform the delete command that you listed on this staging table. Once this is done you could move the records in the staging table to your permanent table and drop the staging table.

Dustin Michaels
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-13 : 04:22:28
quote:
Originally posted by punt

a


Why did you edit the topic like this after getting a reply?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -