Post reply

Weird package creation error

  • 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

  • March 18, 2008 at 5:34 pm

    #791215

    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

  • March 19, 2008 at 8:22 am

    #791459

    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

  • March 31, 2008 at 11:08 am

    #796064

    Thanks,

    I had the same problem. Reparing MSXML 6 helped.

  • September 17, 2008 at 12:47 pm

    #873209

    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??

  • April 27, 2009 at 6:05 pm

    #984784

    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

  • April 30, 2009 at 3:44 pm

    #987029

    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.

  • July 31, 2009 at 1:57 pm

    #1033152

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

  • August 17, 2009 at 3:11 am

    #1040060

    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.

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

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