Post reply

Error trying to import package in SQLServer 2005

  • September 9, 2008 at 10:21 am

    #154707

    I am getting the following error when trying to import a package into SQLServer 2005 from the file system. This package runs fine from within VS2005. Thanks in advance for your help.

    Failed to open package file "C:\Data\WebExport.dtsx" due to error 0xC00CE558 "XML document must have a top level element.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.

  • September 9, 2008 at 11:18 am

    #869181

    Are you positive about the location of the .dtsx file? If you are importing into an SSIS server from Management Studio the file location is relative to the client application, so it needs to be on your local C drive, not that of the server.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply