Weird package creation error

Question

Post reply

Weird package creation error

stricknyn

SSCertifiable

Points: 6560
More actions
March 18, 2008 at 10:07 am

#120518

Hello, everyone. When I create a SSIS package I get a Failed to save package error:
Error creating package
Additional Information:
Failed to save package file "C:\Documents and Settings\jmstricklen\Local Settings\Temp\tmp1C.tmp" with error 0x8002802B "Element not found."."
When I go to the path that was specified in the error message, the file its looking for is there.
Now here what's really weird. Then when I try to create a package again I get the exact same error, only the .tmp file is different. If I go and check again, that .tmp file will be there..and so on. It will keep doing this. This leads me to believe that when the error occurs that .tmp file is being created. I have no idea why this is happening, but I am desperate as I really need to create a package for a client. I've tried uninstalling/reinstalling visual studio 2005 and SQL Server 2005 and I still get the same issue. Has anyone seen this before? Your help would be greatly appreciated.
Thank you,
Strick

Viewing 9 posts - 1 through 8 (of 8 total)

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

Tim Mitchell SSCoach Points: 15681 More actions · Answer 1

Strick,

Try downloading MSXML6 and repairing your installation of same:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=427145&SiteID=1

hth,

Tim

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

stricknyn SSCertifiable Points: 6560 More actions · Answer 2

I actually went completely back to square 1. I went into my Add and remove programs menu, then I uninstalled everythin that said SQL Server 2005. I did the same for Visual Studio 2005. Then I reinstalled SQL Server 2005 first and tested it out and it worked. Then I installed Visual Studio 2005 then I tested it again and it was ok. Looks like everything is ok. Im downloading all the updates now from Microsoft. Thanks for your help.

Strick

andreas-haack Newbie Points: 3 More actions · Answer 3

Thanks,

I had the same problem. Reparing MSXML 6 helped.

jswanson08 Valued Member Points: 55 More actions · Answer 4

also got the "Failed to save package file "C:\WINDOWS\TEMP\tmp96.tmp" with error 0x8002802B" when I tried to create a SSIS package. But when I installed msxml6.msi, I got another error stating that it cannot install because there is a higher version already installed. Now What??

apclist Newbie Points: 3 More actions · Answer 5

Appear to have found a solution - registering MSXML6.0 fixed this problem for me (typing 'regsvr32 %windir%\system32\msxml6.dll' in the run dialog box will do it).

Credit goes to http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/13eafe4f-ff91-4d31-922a-71767c14d3b3

barrykornreich Newbie Points: 3 More actions · Answer 6

Thank you for the answer.

After uninstalling all components of SQL Server 2008

and then reinstalling - I still got the error:

error 0x8002802B "Element not found."

Also all my packages opened with erors and the DataFlow talsks were empty

Your solution to register MSXML6 worked.

I typed 'regsvr32 %windir%\system32\msxml6.dll' in the run window

and everything worked again.

douglara SSC Enthusiast Points: 107 More actions · Answer 7

I had this same problem and registering the dll resolved it!!!

MikeSpike SSC Enthusiast Points: 128 More actions · Answer 8

Registering the dll worked for me too! Tanks a lot!!!

It also solved an issue I had with not being able to save maintenance plans.