• Home
        • Database Development

          Database development is designing, creating a database or data model, and analyzing requirements and their intents as raw data.

          Learn More
        • Architecture & Design

          Software architecture refers to the fundamental structures of a software system and the discipline of creating such structures and systems.

          Learn More
        • Programming

          Computer programming is the process of performing a particular computation or more generally, accomplishing a specific result.

          Learn More
        • Cloud Computing

          Cloud computing is the on-demand availability of computer system resources, especially data storage and computing power.

          Learn More
        • ETL Development

          ETL provides the foundation for data analytics and machine learning workstreams. Through a series of business rules, ETL cleanses and organizes data.

          Learn More
        • Data Visualization & Reports

          Data and information visualization is an interdisciplinary field that deals with the graphic representation of data and information.

          Learn More
  • Blog
  • Contact

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 the 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 the 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 the project deployment model in SSDT has begun supporting the 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 redeploy the entire project every time one made changes to selected packages.
Perhaps, the simplest way to explain why single package deployment is incomparable to the package deployment model is by the following:
Take for instance a new SSIS Catalog server – without any existing projects – as shown below:
Launch your SSDT 2015 project and deploy a single package i.e. PackageA in my example shown below.
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.
Once you have created the project, the OK button becomes available again, thus you can proceed with deployment.
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.




October 11, 2022
Sifiso is Data Architect and Technical Lead at SELECT SIFISO – a technology consulting firm focusing on cloud migrations, data ingestion, DevOps, reporting and analytics. Sifiso has over 15 years of across private and public business sectors, helping businesses implement Microsoft, AWS and open-source technology solutions. He is the member of the Johannesburg SQL User Group and also hold a Master’s Degree in MCom IT Management from the University of Johannesburg.

Meet Our Experts

We are proud to have a team of experts who are passionate about delivering the best possible solutions to you. Our team members are highly skilled and experienced in a diverse range of IT technologies, and are committed to staying up-to-date with the latest industry trends and best practices to deliver you the best results.


Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Join Our Newsletter

Subscribe to get our latest and best thinking on the most definitive workforce topics affecting HR leaders and organizations today.