Extracting dtsx from Integration Service Catalog from C#

Question

From a local C# program, I am trying to connect to an SSMS server's Integration Services Catalog (SSISDB) to read the .dtsx file(s) that are in there. I have the IP/u/p of the server, but after that, how would I get the .dtsx files?

Answer 1

You can extract SSIS projects (including dtsx files) using the SSISDB.catalog.get_project stored procedure. You should use it to save the project as a ".zip" file and extract the packages from it.

You should call this stored procedure from an SQL Command using C# to extract those files. While searching online I found a solution implemented in PowerShell, you can implement the same logic using c#:

• Exports all SSIS projects and packages from a SQL Server 2012 and above SSISDB catalog
• Get packages from SSIS Catalog
• Dumping All Your Microsoft SQL Server Integration Services Packages to Files with PowerShell

---

Similar questions:

• How to export packages deployed in "Integration Services Catalog" using any command line, C# or T-SQL?