Click here to Skip to main content
15,867,832 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

I am trying to save and load SSIS package from SQL Server, can anybody please help me what is missing from my C# Code, here is my code, on the Server all the SSIS packages are placed on the MSDB on Integration Services Engine.

The error that I am getting is:
An unhandled exception of type 'Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException' occurred in Microsoft.SqlServer.ManagedDTS.dll

Additional information: The specified package could not be loaded from the SQL Server database.


My C# code is as below:

Application app = new Application();
Package loadedPkg = app.LoadPackage(@"\\xxx\xxx\edh_imdb\DataExchange\ShieldLink\NewFolder\Brandon\TestSSISPackage\SgLgReporting_SLNewBusinessInProgress.dtsx", null);

// Save the package to SQL Server.
app.SaveToSqlServer(loadedPkg, null, "XXXXXXXS,50101", null, null);

//Application integrationServices = new Application();
Package myPackage = app.LoadFromSqlServer(@"\MSDB", "XXXXXXXS,50101", String.Empty, String.Empty, null);

var temp = myPackage.Execute();


What I have tried:

Searching and trying online and with friend and colleagues, any help would be greatly respected maybe a Code snippet, a link or even a suggestion. Thanks in advance.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900