When SQL 2012 came out earlier this year, one of the biggest changes to its functionality was how the user deploys his or her Integration Services packages. You still have the option to, from Management Studio, attach it to your Integration Service instance, and of course they can be saved in the file system. However, gone is the SSIS Package Store and in its place is the INTEGRATION SERVICES CATALOG (*insert triumphant war cry*)! Now, some may think, “Hey, it’s just got a new name. It’s the same thing, right?” Not true, Doubting Debby. The Catalog is a completely new feature, and will be/has become the preferred way to deploy your Integration Services packages to your server. There are a couple of really big differences between the two, also.
First and foremost, the Catalog is a project level deployment destination, while the old Package Store was done at the package level. This means that with one utility, you will deploy your entire project to the Catalog to be scheduled on the server, rather than having to pick and choose which packages you wish to send. This could be a good thing if you enjoy fewer steps, however if you only want to deploy the packages you need, or if you have packages that are not used anymore, it could make things a little more complicated.
Also, the deployment utility is easy to use. Simply open your project, right click on it in the Solution Explorer, and select “Deploy.” This will open the deployment utility and start you on the path.
Click “Next” to the “Select Destination” page, and then browse to the correct path under the SSISDB directory (You will have to create a folder for your project, so be sure to name it properly).
Click “Next” again to review your deployment, and if everything checks out, go forward in the process to fully deploy your project. You will see an overview of your deployment on the “Results” page.
And that’s it! Now, when you log into Management Studios and the database engine, your whole project is located under the SSISDB directory, ready to be assigned to a job and work for you. Happy ETL’ing!