sql server dts: 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

In message <7b914006.0402271209.5d6583a8@posting.google.com>, Rocio
<rocio.katsanis@softwareservices.net> writes
[quoted text, click to view]

I'm afraid I don't have the answer as I am not a fan of the transfer
objects wizard. Looks like a problem, since it is breaking due to the
order of object creation, but to be honest why not just use backup and
restore?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Well this is intended as a n applcation for a client who does not know
anything about SQL server and how to open, backup & restore files from
it. The weird thing is that, it works fine for 2 other clients, but it
crashes for this one. The only difference between the other clients and
this one is that this one attemps to run the program from a Windows XP
professional environment, and the database is in Windows Server 2003.





*** Sent via Developersdex http://www.developersdex.com ***