Problems with SQL 2005 Export Wizard

I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site.

I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting:

TITLE: Operation stopped...

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.

ADDITIONAL INFORMATION:

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.

BUTTONS:

OK

Here is some more info:

===================================

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.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.PersistImpl.LoadFromXML(XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.LoadFromXML(XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.Configure(ITransferMetadataProvider metadataProvider)
at Microsoft.SqlServer.Dts.DtsWizard.Execute.DoTransferConfigureProvider(Exception& ex)

===================================

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.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageClass.LoadFromXML(Object pNode, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.PersistImpl.LoadFromXML(XmlNode node, IDTSEvents events)

|||I've moved this to the SSIS forum. The error you're hitting looks to be in the SSIS/DTS subsystem. Some one in this forum should be able to help.|||

If LoadFromXML() fails it suggests that your package might be corrupt. Can you take that .dtsx file and open it in BIDS? (just right-click and Edit)

-Jamie

|||Thanks, but there is no package created. I just use Export Data wizard...|||

The Export Data wizard fails at "Create Temporrary XML file for table metadeta". here is mor edetails:

Operation stopped...

- Create a TransferProvider. (Success)

- Create a temporary file for destructive SQL. (Success)

- Create a temporary file for constructive SQL. (Success)

- Create a temporary XML file for table metadata. (Success)

- Configure the TransferProvider with files and Source/Destination connection info. (Error)

Messages

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.

ADDITIONAL INFORMATION:

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.

- Execute the transfer with the TransferProvider. (Stopped)

- Execute the destructive SQL. (drop tables) (Stopped)

- Execute the constructive SQL. (create tables) (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[aspnet_Applications] (Stopped)

- Copying to [dbo].[aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Membership] (Stopped)

- Execute transfer package for [dbo].[aspnet_Membership] (Stopped)

- Copying to [dbo].[aspnet_Membership] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Paths] (Stopped)

- Execute transfer package for [dbo].[aspnet_Paths] (Stopped)

- Copying to [dbo].[aspnet_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Profile] (Stopped)

- Execute transfer package for [dbo].[aspnet_Profile] (Stopped)

- Copying to [dbo].[aspnet_Profile] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[aspnet_Roles] (Stopped)

- Copying to [dbo].[aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Execute transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Copying to [dbo].[aspnet_SchemaVersions] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[aspnet_Users] (Stopped)

- Copying to [dbo].[aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Execute transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Copying to [dbo].[aspnet_WebEvent_Events] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Categories] (Stopped)

- Execute transfer package for [dbo].[CMRC_Categories] (Stopped)

- Copying to [dbo].[CMRC_Categories] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Content] (Stopped)

- Execute transfer package for [dbo].[CMRC_Content] (Stopped)

- Copying to [dbo].[CMRC_Content] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Content_Versions] (Stopped)

- Execute transfer package for [dbo].[CMRC_Content_Versions] (Stopped)

- Copying to [dbo].[CMRC_Content_Versions] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_InventoryHistory] (Stopped)

- Execute transfer package for [dbo].[CMRC_InventoryHistory] (Stopped)

- Copying to [dbo].[CMRC_InventoryHistory] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Logs] (Stopped)

- Execute transfer package for [dbo].[CMRC_Logs] (Stopped)

- Copying to [dbo].[CMRC_Logs] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_OrderItems] (Stopped)

- Execute transfer package for [dbo].[CMRC_OrderItems] (Stopped)

- Copying to [dbo].[CMRC_OrderItems] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Orders] (Stopped)

- Execute transfer package for [dbo].[CMRC_Orders] (Stopped)

- Copying to [dbo].[CMRC_Orders] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_OrderStatus] (Stopped)

- Execute transfer package for [dbo].[CMRC_OrderStatus] (Stopped)

- Copying to [dbo].[CMRC_OrderStatus] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Products] (Stopped)

- Execute transfer package for [dbo].[CMRC_Products] (Stopped)

- Copying to [dbo].[CMRC_Products] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShippingRates] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShippingRates] (Stopped)

- Copying to [dbo].[CMRC_ShippingRates] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShoppingCart] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShoppingCart] (Stopped)

- Copying to [dbo].[CMRC_ShoppingCart] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Copying to [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_TaxRates] (Stopped)

- Execute transfer package for [dbo].[CMRC_TaxRates] (Stopped)

- Copying to [dbo].[CMRC_TaxRates] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Copying to [dbo].[vw_aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Copying to [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Copying to [dbo].[vw_aspnet_Profiles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Copying to [dbo].[vw_aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Copying to [dbo].[vw_aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_User] (Stopped)

|||

Hi all,

I'm having the same problem. Did anybody found a solution for this?

Thanks

|||

Could you guys try to register the xml dlls:

regsvr32.exe msxml3.dll

regsvr32.exe msxml6.dll

HTH.

|||I am having the same problem with my SQL 2005 server (Developer Edition), however, I needed to transform the database to SQL 2000 server. I went to the SQL 2000 box and ran the transform from there and it works fine. I have put all of the latest patches in my 2005 box, updated the MDAC with all versions from 2.6 forward, reinstalled the DTC tools, reinstalled all of the XML patches and updates; still no luck. I did not have this problem until I reformated my HD about 2 weeks ago. Prior to that it all worked fine.|||

After re-instaling, did you also try to register the XML DLLs that Bob suggested? I know they should have been registeded by setup when reinstalling, but just in case ...

Donald Farmer

|||I'm having the same issues and have not done a reinstall. I did try to reregister the referenced .dlls, but it did not help.|||

Has anyone found a solution to this problem yet?

I am trying to run a 'copy database objects' task programatically from vb.net. The SSIS package runs fine from BIDS but fails to load from the file system in the 'loadpackage' call with this 0xc0011008 message.

fyi here is the code...

Private Sub backgroundWorker2_DoWork(ByVal sender As Object, ByVal e As DoWorkEventArgs) Handles BackgroundWorker2.DoWork

Dim pkgLocation As String

Dim pkg As New Package

Dim app As New Application

Dim pkgResults As DTSExecResult

Dim autoEvent As New AutoResetEvent(False)

pkgLocation = e.Argument.ToString()

pkg = app.LoadPackage(pkgLocation, Nothing) ' this is the error line

pkgResults = pkg.Execute()

If pkgResults = DTSExecResult.Success Then

e.Result = "Success"

Else

e.Result = "Failed"

End If

end sub

As you can see this is running on a worker thread.

Does anyone have any ideas?

Thanks and Regards

Ray

|||

Bob Bojanic wrote:

Could you guys try to register the xml dlls:

regsvr32.exe msxml3.dll

regsvr32.exe msxml6.dll

HTH.

This solves this problem.sql