Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS Failing with this error

Posted on 2013-06-23
5
Medium Priority
?
1,110 Views
Last Modified: 2016-02-11
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
Comment
Question by:skaleem1
  • 3
5 Comments
 
LVL 6

Expert Comment

by:Vijay Pratap Singh
ID: 39269379
If you have SQL2008 SP2 installed,  Uninstall  SQL2008 SP2 this should resolve the issue.
0
 
LVL 1

Author Comment

by:skaleem1
ID: 39269442
This is the company server and the same SSIS is running on other servers with SQL2008 SP2 without any such errors...
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39270313
Does have changed XML code of SSIS package?

or opening higher version of SSIS package to lower version on BIDS.
0
 
LVL 1

Accepted Solution

by:
skaleem1 earned 0 total points
ID: 39271118
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
 
LVL 1

Author Closing Comment

by:skaleem1
ID: 39413728
This was the cause of the error
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question