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 TransformData Task

Author  Topic 

cmcilvoy
Starting Member

8 Posts

Posted - 2002-04-17 : 09:51:31

Source: .txt file
Destination: SQL 2000 table

When I execute the DTS step multiple times the table is not updated. I thought if i put a drop table SQL task it would eliminate the problem but then the Transform Data Task errors out. Why?

thanks-
cm


chris mcilvoy
   

- Advertisement -