SSIS Single Package Deployment

When I upgraded my SSIS 2005 project to 2014, the project type was an SSIS package deployment model.  So when I actually deploy to the Integration Services Catalog (ISC), the entire project is recreated every time.  This is totally unacceptable.  Code that goes through testing and is deployed to production needs to be untouched from then on.

I have read the arguments about project deployments and having small solutions.  It appears that the community it trying a work around.

To put it simply, is there ANY way to deploy a single package into an existing project in ISC without touching anything else?

July 14th, 2015 10:08am

You can reverse to the legacy package deployement mode.

Or you can have one/fewer packages in a project.

 

Free Windows Admin Tool Kit Click here and download it now
July 14th, 2015 11:16am

The project is in package deployment mode.  When I use the package deployment wizard on the SSISDeploymentManifest file, it wants to deploy to MSDB instead of the Integration Services Catalog.

Thanks for the help :)

July 14th, 2015 1:39pm

MSDB is not an option after SSIS 2008
Free Windows Admin Tool Kit Click here and download it now
July 14th, 2015 2:47pm

Hi Bryan,

According to your description, you want to deploy a single package instead of entire project to SSIS Catalog in SQL Server 2014.

In SQL Server 2014, the unit of deployment to the SSIS catalog is a SSIS Project. Each SSIS project contains one or more SSIS packages. We couldnt directly deploy a single package in Project Deployment Model, this is by design.

To work around this issue, we can refer to the following suggestion:
SSMS-->Integration Service Catalogs-->SSISDB-->Your project-->projects. Right click on the projects, and choose "Import Packages...". Then make use of the Project Conversion Wizard to select the packages that you want to deploy, deploy the generated .ispac file to SSIS Catalog.

References:
SQL Server 2012 - Project Deployment Model - Deploy a single package

Thanks,
Katherine Xiong

If you have any feedback on our support, please click here.

July 15th, 2015 2:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics