In SSIS 2012 when using Project Deployment Model before we can deploy project we need to create SSIS Catalog and in this article I will describe how to do it.
By Default SSIS Catalog is not created and you have to do perform this one-off task yourself.
First let's connect to the SQL Server 2012 database instance where we want to create the folder I make it bold and I will repeat Database Engine and not Integration Services as it is a little bit confusing.
In my case I connect to localhost (.)
See screenshot below.
In Object Explorer we can see Integration Service Catalogs which is a new SQL Server 2012 Folder. I right click the folder and select Create Catalog.
NOTE: Have you noticed that the folder is called "Integration Services Catalogs" with an -s at the end? that would indicate that you can create multiple Catalogs? Wrong.... or maybe not yet.... Currently you can only create one catalog with name SSISDB this potentially means that Microsoft has some plans to allow to create multiple catalogs in the future.
We get a create catalog dialog box. In my case Enable CLR Integration is grayed out. SSIS 2012 Catalog requires CLR to be enabled but I have already got it enabled so it is grayed out. If you don't have CLR enabled than you will be able to select this checkbox and it will enable CLR Integration after you click OK.
Second option is quite cryptic and you can read more about it here enable automatic execution of Integration Services stored procedure at SQL Server startup
The name of the catalog will be SSISDB and we currently cannot change it.
We have to provide password, without it we won't be able to create the catalog. Remember to store the password somewhere and make backups of keys etc (at this point in time I'm not sure what exactly is involved)
After we click the catalog is craeted and we can start deploying SSIS 2012 Project to it.
For more information SSIS Create Catalog and PowerShell script visit Microsoft site http://msdn.microsoft.com/en-us/library/gg471509.aspx