Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Transfer Objects Task Problem with Check Constraints Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 4:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 1:54 PM
Points: 40, Visits: 55
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
Posted Wednesday, February 20, 2013 6:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 1:54 PM
Points: 40, Visits: 55
Problem solved. Please close this post. Developer Error.
Post #1422372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse