DTS Import from Access

[Kubilus1]

I have an access database with lots of referential integrity that I am trying to import into SQL by DTS. I used the DTS wizard to create a package to delete old data and copy in the new. It seems that the RI is causing several tables to fail when deleting. Is there a way to setup DTS to disable constraint checking during importing and turn back on afterwards? Or is there any other good way of accomplishing this?

Thanks,
Matt

 

[foxdev]

Some constraints can be disabled/enabled (not deleted) by using the ALTER TABLE statement. These include Check constraints. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[tlbroadbent]

You can use NOCHECK and CHECK to disable and enable contraints.

Example from SQL BOL:

-- Disable the constraint.
ALTER TABLE cnst_example NOCHECK CONSTRAINT salary_cap

-- Reenable the constraint.
ALTER TABLE cnst_example CHECK CONSTRAINT salary_cap

Terry

http://members.home.net/tlbroadbent/index.htm