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.