script generated by DTS causes the package to fail

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rocio (rocio.katsanis_at_softwareservices.net)
Date: 02/27/04 

Date: 27 Feb 2004 12:09:06 -0800

This is weird.
I wrote a simple DTS package to copy a server Database to a laptop
database.
The program runs fine, but after probably 1 hour of running (this is a
big db), it fails with the message:

ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint
'FK_Parcel Item Image_Image'. The conflict occurr in db....., table
'Image' column 'ImageID'

now all the scripts to copy the database are generated by DTS itself,
I do not have control of this particular ALTER TABLE statement, what
can I do to solve it?

These are the parameters I use to copy the database:

Create destination objects (tables, views, stored procedures,
constraints, etc.)
   Drop destination objects first
   Include all dependent objects
   Include extended properties
Copy Data
   Replace Existing data
Use Collation
Copy all objects

In Options I setup:
Copy database users and database roles
Copy SQL Server Logins (Windows and SQL Server Logins)
Copy object-level permissions
Copy indexes
Copy triggers
Copy full-text indexes
Copy PRIMARY and FOREIGN keys
Use quotes identifiers when copying objects

any ideas on how to solve this?

Relevant Pages

  • Re: Scheduled package appears to fail when new tables are added - why?
    ... > We have a scheduled DTS package which transfers a database (tables, ... > database is causing the database to fail. ... > specifically create destination objects and replace the existing data. ... > tables to the source database, the destination database will always mirror ...
    (microsoft.public.sqlserver.dts)
  • Re: sp_change_users_login doesnt work for me
    ... be used only with the security accounts of SQL Server logins and users; ... cannot be used with Microsoft Windows NTŪ users." ... If that is not your case, then a database should always restore with its ...
    (microsoft.public.sqlserver.security)
  • Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?
    ... Users password: ... All the SQL Server logins and passwords are stored in MASTER database. ... you restore a database independently to a new server the ...
    (microsoft.public.sqlserver.server)
  • Re: asp.net 2.0 connectoin string (hopefully last question)
    ... Make sure that your username / login is attached to the ... Another option could be that your database is not setup to use SQL ... change the security option to allow SQL Server logins. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Copy SQL Server Objects Fails for certain views
    ... Backup/Restore as transparent to the customer as our DTS package currently ... Our customers don't typically know a database from a monkey wrench. ... Copy objects just uses an alphabetical order. ...
    (microsoft.public.sqlserver.dts)