Project Creation Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Project Creation Error

Author

Topic

swathigardas
Posting Yak Master

149 Posts

Posted - 2009-07-07 : 06:14:56

Hi,
When i try to create a project in ssis , i am getting the following error -
Failed to save package file "C:\Documents and Settings\swathi.g\Local Settings\Temp\tmp82E.tmp" with error 0x8002801D "Library not registered.".

Also when i am trying to open an existing project following error is seen -

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

Error 1 Error loading TroubleShootDataInFlow.dtsx: Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered.
Error 2 Error loading TroubleShootDataInFlow.dtsx: Unable to load from XML.
Error 3 Error loading TroubleShootDataInFlow.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.

Any idea what does this error mean.. This error has not come before 2 months when i was working on SSIs. I am new bie to this. Please help me out

Haarish
Starting Member

30 Posts

Posted - 2009-07-07 : 06:34:55

Hi Swathi,

I searched for some information and this is the solution that has worked for a lot of people with the same problem. Try downloading MSXML6 and repair the corrupted files. You can read through to find some more information - http://social.msdn.microsoft.com/Forums/en-US/sqlxml/thread/5b259308-1c7a-49ee-898b-09f5b6807e38.

Thanks,
Haarish.

swathigardas
Posting Yak Master

149 Posts

Posted - 2009-07-07 : 06:45:02

Thanks haarish. It worked perfectly when i installed MSXML 4.0
FROM

http://www.microsoft.com/downloads/details.aspx?familyid=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en#filelist

Bendaberg
Starting Member

2 Posts

Posted - 2009-08-09 : 00:41:29

I had this error recently after applying SP3 (to SQL 2005)

The problem was because I had relocated my "ServicePackFiles" directory from C: to D: (was having major space issues) and the dll's were failing to register.

kkmurthy
Starting Member

41 Posts

Posted - 2010-05-25 : 13:32:21

I have the same problem. I have a Project with bunch of packages.When I try to open the solution using Business intelligence studio, I am getting the sam error. I downloaded the MSXML6 and I did not understand how to repair the packags. Can you please let me know how you repaired the project in business intelligence studio
KKM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources