Tuesday, March 20, 2012

Cannot open SSIS project in BIDS

Hi,
I have been working on an SSIS project for sometime now. The project files are located on a remote server. Suddenly I am not able to open the solution I get a lot of error messages and all the data flow taks are gone. I later found out that SSIS encrypts packages, so that other users will not be able to see them. Fine, but I have been using the same windows user account for months now. What could be the problem?
This is what I get when trying to open the solution:

There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.

And the error list also contains messages saying "Could not load from xml".

Any pointers will be much appreciated.

TIA
Can you please post the specific errors you are receiving? You can copy and paste from the error list.|||Hi,
thanks for that quick reply.
Here are the error messages from the error list.
There are 9 control flow tasks and these three messages seem to
occur for all of them.

Error 1
Error loading RecruteToTempJobs01.dtsx: Unable to instantiate
XML DOM document, please verify that MSXML binaries are properly
installed and registered.
d:\ssis\
RecruteToTempJobs01.dtsx

Error 2
Error loading RecruteToTempJobs01.dtsx: Unable to load from
XML. d:\ssis\
RecruteToTempJobs01.dtsx

Error 3
Error loading RecruteToTempJobs01.dtsx: Error loading a task.
The contact information for the task is "Performs high-performance data
extraction, transformation and loading;Microsoft Corporation; Microsoft
SQL Server v9; (C) 2004 Microsoft Corporation; All Rights
Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when
loading a task fails.
d:\ssis\
RecruteToTempJobs01.dtsx|||

Could you try to register xml libraries on your machine:

regsvr32 msxml3.dll

regsvr32 msxml6.dll

Try to search this forum and you will find a lot of details about issues similar to the one you are seeing.

Thanks.

|||Thanks a ton Bob, that worked!

Just curious, what could have happened to require the dlls to be registered. I didn't register them before and things were working fine.

Thanks once again!
|||

I do not remember exactly. Some setup issues...

Try to search this forum, there was a lot of posts about this.

Thanks.

|||This is quite likely a setup issue in an entirely different application. These DLLs are used by a wide range of applications, and any one of them could have a dodgy installer, stuff you may not even think about. For example I have seeen several instances of "security patches" being deployed via SMS that have broken the registration for one or more of the MSXML versions.|||

Thanks for the information Darren,

the culprit must be one of those 'security patches' in my case I guess!

Thanks.

No comments:

Post a Comment