Get Ssis Package Name With C#

I'm copying SSIS packages from one SQL server to another in a C# program via DTUTIL. The packages are in MSDB. string dtutilCmd = '/c DTUTIL /SOURCESERVER ' + sourceServer + ' /SQL

Solution 1:

All you need to do is make use of 'Application' class of Microsoft.Dts.Runtime namespace. You then establish a connection using that and get the packages info from the MSDB.

Here is link that gives more details on how to go about doing it programatically - Enumerating Available Packages Programmatically

Solution 2:

Extract your Integration Service Catalog to ispac. Open it with SSDT, and deploy to your new server. Much easier.