Post reply

Creating DTS package

  • November 19, 2007 at 8:52 am

    #181159

    Hi All,

    I have been working with DTS packages for a while now. I am trying to create a new DTS package which includes 8 tables. I created a DTS package which deletes all 8 tables and then creates it in the new database and populates them.

    this was working fine. there were some changes regarding foreign key. now the DTS package errors out saying that the table cannot be dropped because it has a refference pointing to another table.

    These databases are in SQL server 2000 sp4. how do i get this package to work? Is script the only way? can DTS package wizard handle this situation?

    Thank you,

    Sathya.

  • November 19, 2007 at 8:57 am

    #752333

    First, post these in the DTS forum.

    Second, if you need to drop the FK, you can drop it with an Execute SQL task set up to run before you drop the tables, then I'd set up a similar Execute SQL task at the end to add back the FK.

    Be sure the missing FK will not cause you issues with data intregrity. The other thing is to have the first Execute SQL task instead delete the child data if that is appropriate.

  • November 20, 2007 at 1:34 pm

    #752872

    Drop the tables in the correct order, then there should be no issue. Start with the tables that are not parents to other tables and work you way up until all 8 are gone.

    Regards,

    Norman

    DTS Package Search

    http://www.dtspackagesearch.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply