SSIS Transfer Objects Task Problem with Check Constraints

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSIS Transfer Objects Task Problem with Check...

SSIS Transfer Objects Task Problem with Check Constraints

Rate Topic

Display Mode

Topic Options

Author

Message

dsorensen 97289

Posted Tuesday, February 19, 2013 4:49 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 4:41 PM
Points: 4, Visits: 46

I'm trying to develop a simple SSIS (2008) package that will be used to copy all the objects from a "template" SQL 2008 database to a new 2008 database. The idea is that it will be run after a new database is created.

I've set up a simple Transfer SQL Server Objects Task with everything set to True except CopySqlServerLogins, which I don't want to do. The transfer runs successfully with no errors, but when I check the destination database afterwards....

The tables that contain check constraints were not copied! Everything else is there. Tables (including those with default constraints), Indexes, SProcs, and Users are all intact. The one common factor that seems to be causing the issue are the check constraints. Does anyone have any experience with this? Any help is much appreciated.

~Dave

Post #1421890

dsorensen 97289

Posted Wednesday, February 20, 2013 6:15 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 4:41 PM
Points: 4, Visits: 46

Problem solved. Please close this post. Developer Error. Blush

Post #1422372

« Prev Topic | Next Topic »

Permissions