1
Vote

Just installed...need assistance..

description

Just installed ssisunit.......invoking New From Package, after selecting package, I get the following:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: 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.
---> System.Runtime.InteropServices.COMException (0xC0011008): 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.

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
at ssisUnitTestRunnerUI.testSuiteUI.CreateTestFromPackage(String fileName)
at ssisUnitTestRunnerUI.testSuiteUI.newFromPackageToolStripMenuItem_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

ssisUnitTestRunnerUI2008
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///C:/Program%20Files/AgileBI/ssisUnit2008/ssisUnitTestRunnerUI2008.exe

System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5468 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Microsoft.SqlServer.ManagedDTS
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ManagedDTS/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ManagedDTS.dll

Microsoft.SqlServer.DTSRuntimeWrap
Assembly Version: 10.0.0.0
Win32 Version: 2009.0100.1600.01 ((KJ_RTM).100402-1540 )

CodeBase: file:///C:/Windows/assembly/GAC_32/Microsoft.SqlServer.DTSRuntimeWrap/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.DTSRuntimeWrap.dll

SsisUnit2008
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///C:/Program%20Files/AgileBI/ssisUnit2008/SsisUnit2008.DLL

SsisUnit2008.Design
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///C:/Program%20Files/AgileBI/ssisUnit2008/SsisUnit2008.Design.DLL

Microsoft.SqlServer.SqlTDiagM
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

Microsoft.SqlServer.Diagnostics.STrace
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Diagnostics.STrace/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Diagnostics.STrace.dll

System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

file attachments

comments

johnwelch wrote Apr 23, 2013 at 2:49 PM

What version of SSIS was the package created in?

mpeiffer wrote Apr 23, 2013 at 4:38 PM

John
Thanks for the quick response... See the following

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Installed Version: IDE Standard

Microsoft Visual Basic 2010 01011-532-2002361-70763
Microsoft Visual Basic 2010

Microsoft Visual C# 2010 01011-532-2002361-70763
Microsoft Visual C# 2010

Microsoft Visual Studio Tools for Applications 3.0 01011-532-2002361-70763
Microsoft Visual Studio Tools for Applications 3.0

Microsoft Visual Web Developer 2010 01011-532-2002361-70763
Microsoft Visual Web Developer 2010

Security Update for Visual Studio 2010 Shell (Isolated) - ENU (KB2645410) KB2645410
This security update is for Visual Studio 2010 Shell (Isolated) - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2645410.

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 11.0.2100.60

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 11.0.2100.60

Visual Studio 2010 Shell (Integrated) - ENU Service Pack 1 (KB983509) KB983509
This service pack is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.

johnwelch wrote Apr 24, 2013 at 7:03 PM

OK, you are using SSIS 2012. The install version on the website doesn't support 2012 yet, but the latest check-ins do. Currently, I recommend that you download and compile the latest source for 2012 support.

I'm planning to put a new installer out soon with 2012 support, but I would like to get in a few more fixes before that happens.

alishahnawazm wrote Aug 6, 2013 at 9:29 PM

Hello John -

Since my SSIS has the following version
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60

I downloaded the latest source from http://ssisunit.codeplex.com/SourceControl/latest# (attached) to compile it in Visual Studio 2010, but it gives me the following errors:

Error 2 The command "copy "C:\EDW\ssisunit\ssisunit-103218\SsisUnit.TestComponents\bin\Debug\SsisUnit.TestComponents.dll" "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents"
"c:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -if "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents\SsisUnit.TestComponents.dll"" exited with code 3. SsisUnit.TestComponents

Error 3 Metadata file 'C:\EDW\ssisunit\ssisunit-103218\SsisUnitDesign\bin\Debug\SsisUnit2008.Design.dll' could not be found ssisUnitTestRunnerUI_SQL2008

Error 5 The command ""C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\gacutil.exe" -u SsisUnit2008.Design.dll" exited with code 3. SsisUnit.Design_SQL2008

FYI, my packages are in VS 2010 talking to SQL Server 2012.

Could you please advise on this.

Thanks in advance, Shahnawaz

johnwelch wrote Aug 7, 2013 at 6:39 PM

You need to update the Post Build command lines in the project for your environment. You may also need to run Visual Studio as an administrator, so that you have rights to GAC the SSIS components.

alishahnawazm wrote Aug 7, 2013 at 7:57 PM

Thanks. I was able to build and run this in VS 2010 after updating the Post Build command lines and running as admin. However I see the following errors when I try to load an existing SSIS package (attached) created in VS 2010 and talking to SQL Server 2012. I really need to make this work, so that we can start using ssisUnit as our unit testing framework in my organization:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: 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.
---> System.Runtime.InteropServices.COMException: 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.

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
at ssisUnitTestRunnerUI.testSuiteUI.CreateTestFromPackage(String fileName) in C:\EDW\ssisunit\ssisunit-103218\ssisUnitTestRunnerUI\TestBuilder.cs:line 201
at ssisUnitTestRunnerUI.testSuiteUI.newFromPackageToolStripMenuItem_Click(Object sender, EventArgs e) in C:\EDW\ssisunit\ssisunit-103218\ssisUnitTestRunnerUI\TestBuilder.cs:line 191
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL

CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

ssisUnitTestRunnerUI2008
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///C:/EDW/ssisunit/ssisunit-103218/ssisUnitTestRunnerUI/bin/Debug/ssisUnitTestRunnerUI2008.exe

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18036 built by: FX45RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18021 built by: FX45RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.18021 built by: FX45RTMGDR

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.ManagedDTS
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.ManagedDTS/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ManagedDTS.dll

Microsoft.SqlServer.DTSRuntimeWrap
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )

CodeBase: file:///C:/Windows/assembly/GAC_32/Microsoft.SqlServer.DTSRuntimeWrap/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.DTSRuntimeWrap.dll

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

SsisUnit2008
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///C:/EDW/ssisunit/ssisunit-103218/ssisUnitTestRunnerUI/bin/Debug/SsisUnit2008.DLL

SsisUnit2008.Design
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/SsisUnit2008.Design/1.0.0.0__6fbed22cbef36cab/SsisUnit2008.Design.dll

Microsoft.SqlServer.SqlTDiagM
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1750.9 ((dac_inplace_upgrade).101209-1051 )

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

Microsoft.SqlServer.Diagnostics.STrace
Assembly Version: 10.0.0.0
Win32 Version: 10.50.1750.9 ((dac_inplace_upgrade).101209-1051 )

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Diagnostics.STrace/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Diagnostics.STrace.dll

System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.17929 built by: FX45RTMREL

CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

johnwelch wrote Aug 7, 2013 at 8:26 PM

Make sure you are building the 2012 version of the projects, and not the 2008 version. There's a different solution file for 2012.

alishahnawazm wrote Aug 7, 2013 at 10:22 PM

My bad. I was using the 2010 solution instead of 2012. Works fine now. Thanks and appreciate your prompt response.