Not sure why this happens, but I was trying to create an SSIS package on my work machine (this'll be my first SSIS package since DTS died), and recieved a weird error:

Failed to save package file "C:\TEMP\tmp18D.tmp" with error 0x8002802B "Element not found"

Turns out that this is due to MSXML6 not being registered. I found the solution here:

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

Basically:

To register MSXML 6.0.
1. From the Start menu, click Run.
2. Enter the following command:. regsvr32 %windir%\system32\msxml6.dll.
3. Click OK. ...

Hope this helps someone else, like it helped me.

~L

posted on Thursday, April 10, 2008 4:46 AM | Filed Under [ Learning SSIS ]

Comments

Gravatar
# re: Creating SSIS Package Error
Posted by Michael Wandha
on 4/15/2008 1:53 AM
Please someone outthere help me. I have installed all packages as explained to create SSIS package. When I open BIDS and select Ne project, Unders BI Project, I see only two templates both for Reports. There is no option to create SSIS package. How do I get this possibility.
Thanks
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 4/15/2008 2:56 PM
@Michael: The only thing I can suggest is making sure that Integration services is installed.

Wish I could be more help
~L
Gravatar
# re: Creating SSIS Package Error
Posted by awilbur
on 4/22/2008 5:28 PM
Gracias, this info saved me a bit of time today.
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 4/22/2008 9:06 PM
@awilbur: Awesome! glad it helped.
Gravatar
# re: Creating SSIS Package Error
Posted by Tobby
on 5/5/2008 6:16 PM
Thank You. You just saved me a lot of time. I got the exact error and was thinking about re-installed BIDS since it was working before on my workstation but I thought I'd google the error first.

Registered msxml6 and off it goes.
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 5/5/2008 10:26 PM
Thanks Toby! I'm glad this helped!
Gravatar
# re: Creating SSIS Package Error
Posted by Riaan
on 5/21/2008 9:03 AM
You saved me HOURS of re-installation. Thank you...
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 5/21/2008 9:06 AM
@Riaan, I am glad this helped you. What a great way to start the day! :0)
Gravatar
# re: Creating SSIS Package Error
Posted by Naijel
on 6/19/2008 5:24 AM
Thanks a lot Lee.. you save me lot of time. Thanks
Gravatar
# re: Creating SSIS Package Error
Posted by TVO
on 6/25/2008 1:21 PM
Thank you for the SIMPLE and clear instructions. This fixed me.
Gravatar
# re: Creating SSIS Package Error
Posted by Dwayne
on 8/25/2008 12:46 PM
MANY, MANY THANKS!!! to the person at the top that recommended registering MSXML6...I was just about to uninstall Visual Studio AND SQL Server components, after slamming my head in the oven door all weekend!!
:-)
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 8/25/2008 1:18 PM
Naijel & Dwayne I'm so glad this is helping people.
Gravatar
# re: Creating SSIS Package Error
Posted by ja
on 9/23/2008 7:58 AM
thanks again... saved me a lot of work figuring out why even a basic copy of a db wouldn't work. works perfectly now.
Gravatar
# re: Creating SSIS Package Error
Posted by Jared
on 9/23/2008 12:32 PM
Thanks Lee. That was a HUGE help.
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 9/23/2008 1:50 PM
@Jared & @Ja thanks for reading!!! Glad it helped!
Gravatar
# re: Creating SSIS Package Error
Posted by JB
on 9/24/2008 12:52 PM
worked for me, thanks
Gravatar
# re: Creating SSIS Package Error
Posted by gtg
on 9/26/2008 1:01 PM
Simple fix that worked great! Thanks!
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 9/26/2008 2:11 PM
@JB && @gtg: I'm so totally glad this is helping you guys.
Gravatar
# re: Creating SSIS Package Error
Posted by Michelle
on 10/17/2008 1:19 PM
Awesome! Thanks, I have been looking for this for quite a while. You saved my sanity... for today. :-)
Gravatar
# re: Creating SSIS Package Error
Posted by dare
on 2/4/2009 1:28 AM
Thanks its work superb
Gravatar
# re: Creating SSIS Package Error
Posted by George
on 3/6/2009 11:42 AM
Worked great, I spent time doing the repair thing and it did not work..this did!
Gravatar
# re: Creating SSIS Package Error
Posted by Lee Brandt
on 3/6/2009 1:29 PM
I am so glad this is helping people.
Gravatar
# re: Creating SSIS Package Error
Posted by Serg
on 10/16/2009 12:56 PM
Still does help. Thanks a lot!!!
Gravatar
# re: Creating SSIS Package Error
Posted by Quinx
on 10/21/2009 2:38 PM
Anyone have any idea what causes this issue?
Gravatar
# re: Creating SSIS Package Error
Posted by Wellboy
on 11/3/2009 9:00 AM
thank you ! fix for me :-)
Gravatar
# re: Creating SSIS Package Error
Posted by Mike
on 1/4/2010 9:39 AM
Thanks, that probabaly saved me a lot of time!
Post Comment
Title *
Name *
Email
Url
Comment *