Click here to Skip to main content
13,801,048 members
Click here to Skip to main content
Add your own
alternative version

Tagged as

Stats

2.3K views
1 bookmarked
Posted 31 Jan 2017
Licenced CPOL

Single package Deployment Does Not Replace Package Deployment

, 31 Jan 2017
Rate this:
Please Sign up or sign in to vote.
Single package deployment does not replace package deployment

In my article, Single package deployment in SQL Server Integration Services 2016, I covered the exciting single package deployment feature available in SQL Server 2016 via SQL Server Data Tools (SSDT) 2015. I think in the midst of the excitement, some people started confusing this new feature with package deployment model. In this post, I try to clear out any confusion so people can be better informed before they join in the excitement.

Single package deployment was always supported in package deployment model. This support did not just start with SSDT but it was the only deployment model support in BIDS (Business Intelligence Studio). The exciting part is that now project deployment model in SSDT has begun supporting deployment of a single package within a project instead of deploying the entire project. Prior to this, we were sitting with a situation of having to re-deploy the entire project every time one made changes to selected packages.

Perhaps, the simplest way to explain why single package deployment is incomparable to package deployment model is by the following:

Take for instance a new SSIS Catalog server – without any existing projects – as shown below:

ssdep7

Launch your SSDT 2015 project and deploy a single package, i.e., PackageA in my example shown below:

ssdep1

You will soon realize that you cannot proceed with the deployment as the OK button is disabled. Instead, you are required to first create a project (by clicking the New project… button) before you can deploy the single package.

ssdep2

Once you have created the project, the OK button becomes available again, thus you can proceed with deployment.

ssdep3

This works differently from the package deployment model which allows you to deploy a single package to SQL Server, file system or, package store without firstly creating a project.

It’s that simple, folks!

Until next time, cheers.

Sifiso

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Sifiso W Ndlovu
Technical Lead select SIFISO
South Africa South Africa
Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web01 | 2.8.181215.1 | Last Updated 31 Jan 2017
Article Copyright 2017 by Sifiso W Ndlovu
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid