SQLTeam.com | Weblogs | Forums

Need to move a solution (package, whatever)?


Hope someone can help.

I've never fully got my head around the SSIS hierarchy (I think a solution contains projects which themselves contain packages but I'm probably wrong?)

Anyhow, my company want to move a fully working solution/project/packages from one server to another.

What do I need to do?

Up to SQL Server 2008 the package deployment model was the only deployment model. With the package deployment model a package is independently deployed. With the project deployment model a project can contain multiple packages and variables can be declared at a project level and be shared as well as connections and parameters. Also with the project deployment model objects are stored in MSDB and project deployment model objects are stored in the SSISDB.

1 Like