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);
app.SaveToSqlServer(loadedPkg, null, "XXXXXXXS,50101", null, null);
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.