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
 SQL Server Administration (2000)
 DTS Integrity Checks

Author  Topic 

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2001-03-07 : 05:37:50
We're using SQL2K.

If we have an external data file that we need to get into one of our DBs.

What kind of integrity checks do people carry out on the data prior to committing the data to a DB. e.g. missing PK ? Duplicates ?

Just wondering whether we should be doing more than we are which is very little to be honest.

thanks

   

- Advertisement -