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)
 CD bill import , mdf to SQL

Author  Topic 

nhaas
Yak Posting Veteran

90 Posts

Posted - 2006-08-04 : 14:58:53
I recieve a new cd bill from our phone company everymonth. I want to set up a DTS just to tell it to run (which I have). The cd bill MAY change once in a while. Is there a way to tell DTS to first do a test run to make sure that the dozen or so table are identical and will run correctly? Then if there are no errors to go ahead and just do the import.

Or am I just way off and should try something else?
   

- Advertisement -