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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-25 : 17:27:25
|
Rachid writes "I am using DTS to load a number of tables in my database from flat files. (The data comes from the mainframe).
I first disable all the foreign key constraints, load the data then enable the constraints. Enabling the constraints ensures that any subsequent inserts/updates/deletes are validated but does not validate loaded data.
The question is: how do I validate the loaded data?
We are using SQL Server 7 SP2.
Thank you very much for you help.
Rachid" |
|
|
|
|
|
Validating data after DTS Load