• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1148
  • Last Modified:

SSIS Failing with this error

I have an SSIS that imports data from a flat file and is failing with the following message:

Error      60      Error loading 'OptInInformation.dtsx' : Failed to load XML due to error 0xC00CE504 "A name was started with an invalid character. Line 13, Column 2". This happens when loading a package and the file cannot be opened or loaded correctly into XML document.  This can be the result of either providing an incorrect file name to the LoadPackage method or the XML file specified having an incorrect format.  .      C:\SSMS\SSMS-SSIS\SSMS_PRE\4 - GEO - Pre SSMS\GEO - Pre SSMS\GEO - Pre SSMS\GEO- Pre SSMS\InInformation.dtsx      1      1

Please help!
0
skaleem1
Asked:
skaleem1
  • 3
1 Solution
 
Vijay Pratap SinghCommented:
If you have SQL2008 SP2 installed,  Uninstall  SQL2008 SP2 this should resolve the issue.
0
 
skaleem1Author Commented:
This is the company server and the same SSIS is running on other servers with SQL2008 SP2 without any such errors...
0
 
Alpesh PatelAssistant ConsultantCommented:
Does have changed XML code of SSIS package?

or opening higher version of SSIS package to lower version on BIDS.
0
 
skaleem1Author Commented:
The XML code appears to be the same in both servers.

What do you mean by opening higher version of SSIS package to lower version of BIDS (what is BIDS)?

Comparing the DEV server with the other two servers (note that the same .dtsx package is running successfully in the SIT and UAT servers), this was the first clear difference I could notice. I found out that version for Microsoft MSXML installed on the DEV server is not the same as the one on SIT and UAT servers respectively. Here is the comparison:

DEV Server:
Microsoft MSXML                  3.0 5.0 6.0

SIT and UAT Servers:
Microsoft MSXML                  3.0 6.0

Would that possibly be the cause of the error mentioned in the original question?
0
 
skaleem1Author Commented:
This was the cause of the error
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now