Problems with SQL 2005 Export Wizard

Problems with SQL 2005 Export Wizard

• chrisexv6

  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.
  
  

• ronnotel

  Hi all,

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

  Thanks

  
  
  

• webwize

  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.
  

• Matthew deWet

  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

  
  
  

• Bernybon

  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.
  
  
  

• mh433493

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

• doakwolf

  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)
  

  
  
  

• RogerDontLikeReports

  Could you guys try to register the xml dlls:

  regsvr32.exe msxml3.dll

  regsvr32.exe msxml6.dll

  HTH.

  
  
  

• Michael Wayne

  Unfortunately, if it did solve the problem for someone, it does not solve the problem for everyone. I am attempting to load a package using an SSIS Application object and I am receiving the exact same error. I am using VS2005, C#, I do not have a version of SQL server on my local machine, but I do have all of the client tools. My development box is an XP Pro box with all current service packs. I am able to create a Package and even execute it, but when I try just to load it I receive the same error as described earlier in this thread. Does anyone know why I would receive this error when attempting to load a package

  
  

• Nicolas V

  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

  
  
  

• SteveS_MS

  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)

  
  
  

• Gomathi Sarma

  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.
  

• Martha Wieczorek

  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

  
  
  
• Problems with SQL 2005 Export Wizard