Creating an SSIS Catalog with PowerShell

Here’s how to deploy SQL Servers in an organization with custom business intelligence.

When deploying SQL Servers and when you need to implement some of kind of business intelligence, chances are you’re going to need a SQL Server Integration Services (SSIS) catalog. A SSIS catalog is a required piece for performing workflow functions, loading ETL packages and more. By using the Microsoft.SqlServer.Management.IntegrationServices.dll library, we can use PowerShell to automate the creation of an SSIS catalog along with folders inside.

Before we get started writing code, if you haven’t already, you’ll first need to install SQL Server Management Studio. This should get you the required libraries necessary to talk to the SQL Server. Once that’s done, ensure you have at least PowerShell v4 installed. When you’ve met both of those prerequisities, you’re ready to begin coding!

Read more at MCPMag

Leave a Reply