Hello,

What is the easiest way to avoid constraint check problems when using DTS?
Is there a way to disable constraints temporarily to allow DTS to run
smoothly?

With constraints enabled, I have to export / import tables at a hierarchical
order. This could be a pain...Obviously, this will generate problems related
to data integrity but, in my case, data is secure and consistent.

Regards,
Fernando.

You can disable all constraints. ALTER TABLE tablename NOCHECK CONSTRAINT
constraintname. Add an Exec SQL Task to disable constraints, then add a task
to reenable them afterwards. It may be better to just drop them and then
recreate however.

Quick search revealed the following as well-

http://www.databasejournal.com/scrip...le.php/1459571

http://www.umachandar.com/technical/...pts/Main37.htm



--
Darren Green
http://www.sqldts.com

"Fernando Poinho Malard" <fernando (AT) graphsystem (DOT) com> wrote