469,342 Members | 6,653 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

Error : Calling SSIS package from .Net

I am calling SSIS package from a .Net windows UI. Both SSIS & .Net app are created in 2008. The SSIS package is stored in file system. When I ran .Net app I got error-



The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.




Exception Detail -

Microsoft.SqlServer.Dts.Runtime.DtsRuntimeExceptio n was unhandled
HelpLink="#-1073659847"
Message="The package failed to load due to error 0xC0011008 \"Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.\". This occurs when CPackage::LoadFromXML fails.\r\n"
Source=""
ErrorCode=-1073672184
StackTrace:
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPa ckage(String fileName, IDTSEvents events, Boolean loadNeutral)
at SSISCall.Form1.Execute_Click(Object sender, EventArgs e) in D:\SSISCall\SSISCall\Form1.cs:line 36
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallba ck(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchM essageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager. System.Windows.Forms.UnsafeNativeMethods.IMsoCompo nentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.Run MessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.Run MessageLoop(Int32 reason, ApplicationContext context)
at SSISCall.Program.Main() in D:\SSISCall\SSISCall\Program.cs:line 17
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
at System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: System.Runtime.InteropServices.COMException
HelpLink="#-1073659847"
Message="The package failed to load due to error 0xC0011008 \"Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.\". This occurs when CPackage::LoadFromXML fails.\r\n"
Source=""
ErrorCode=-1073672184
StackTrace:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.Applicatio nClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPa ckage(String fileName, IDTSEvents events, Boolean loadNeutral)
InnerException:



The code that I am using is very simple -



string packageLocation;

Package ssisPackage;

Microsoft.SqlServer.Dts.Runtime.

Application ssisApplication;

DTSExecResult ssisPackageResult;

packageLocation = @"D:\SSISCall\Package.dtsx" ;

ssisApplication = new Microsoft.SqlServer.Dts.Runtime.Application ();

ssisPackage = ssisApplication.LoadPackage(packageLocation, null ); ----Getting error here

ssisPackageResult = ssisPackage.Execute();

Console.WriteLine(ssisPackageResult.ToString());
Console.ReadKey();

Please suggest.
Oct 26 '09 #1
0 2750

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Rodrigo Bellusci | last post: by
reply views Thread by =?Utf-8?B?RGF2aWQgTG96emk=?= | last post: by
2 posts views Thread by pvong | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.