August 18, 2015 at 3:53 pm
We are upgrading 2 server from SQL 2008 to SQL 2014.
I found in SSIS solution, there are two ways to deploy ssis packages, one is project mode the other is package mode.
We usually just copy the SSIS package file .dtsx to the server. We don't deploy it directly from Visual studio.
Does it matter if we are in project deploy mode or we have to convert it to package deploy mode?
Thanks,
August 24, 2015 at 7:40 am
You can use either Project or Package deployment mode.
Each sub-"package" within the solution must be the same type.
Recommendation is to use Project, which I use only, as there are certain "best practice" objects that become available to you.
If you use "Package" deployment model then each package must be deployed to server individually.
With Project you can configure parameters and use common shared data sources and deploy entire solution of packages in one go.
The shared connections and parameters are only available in Project Deployment mode.
You can also use the "master-child" configuration whereby a parent "package" then calls a sequence of sub-projects or packages.
When you upgrade from 2008 to 2014 all your packages will initially be in Package Deployment mode.
Just right-click eech package to convert to Project Deployment mode.
Be sure to follow this procedure with your connections also.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply