Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> SQL Server Integration Services

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:

BUTTONS:

[977 byte] By [RADIOGENERIS] at [2007-12-19]

«« Returning reference not in prototype
»» Word Document

# 1

Here is some more info:

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

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)

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

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)

RADIOGENERIS at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

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.

DanJonesMSFT at 2007-9-8 >

# 3

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

JamieThomson at 2007-9-8 >

# 4

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

RADIOGENERIS at 2007-9-8 >

# 5

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

ADDITIONAL INFORMATION:

- 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)

RADIOGENERIS at 2007-9-8 >

# 6

Hi all,

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

Thanks

Gette at 2007-9-8 >

# 7

Could you guys try to register the xml dlls:

regsvr32.exe msxml3.dll

regsvr32.exe msxml6.dll

HTH.

BobBojanic at 2007-9-8 >

# 8

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.

ChuckLeonard at 2007-9-8 >

# 9

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

DonaldFarmer at 2007-9-8 >

# 10

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.

ChipDowns at 2007-9-8 >

# 11

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

rgudgeon at 2007-9-8 >

# 12

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.

JonLimjap at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Problems with SQL 2005 Export Wizard...'

Problems with SQL 2005 Export Wizard

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified