Geeks With Blogs
Lee Brandt's Blog You're only as smart as your last line of code

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 Learning , SSIS | Back to top


Comments on this post: Creating SSIS Package Error

# re: Creating SSIS Package Error
Requesting Gravatar...
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
Left by Michael Wandha on Apr 15, 2008 1:53 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
@Michael: The only thing I can suggest is making sure that Integration services is installed.

Wish I could be more help
~L
Left by Lee Brandt on Apr 15, 2008 2:56 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Gracias, this info saved me a bit of time today.
Left by awilbur on Apr 22, 2008 5:28 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
@awilbur: Awesome! glad it helped.
Left by Lee Brandt on Apr 22, 2008 9:06 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
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.
Left by Tobby on May 05, 2008 6:16 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks Toby! I'm glad this helped!
Left by Lee Brandt on May 05, 2008 10:26 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
You saved me HOURS of re-installation. Thank you...
Left by Riaan on May 21, 2008 9:03 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
@Riaan, I am glad this helped you. What a great way to start the day! :0)
Left by Lee Brandt on May 21, 2008 9:06 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks a lot Lee.. you save me lot of time. Thanks
Left by Naijel on Jun 19, 2008 5:24 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you for the SIMPLE and clear instructions. This fixed me.
Left by TVO on Jun 25, 2008 1:21 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
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!!
:-)
Left by Dwayne on Aug 25, 2008 12:46 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Naijel & Dwayne I'm so glad this is helping people.
Left by Lee Brandt on Aug 25, 2008 1:18 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
thanks again... saved me a lot of work figuring out why even a basic copy of a db wouldn't work. works perfectly now.
Left by ja on Sep 23, 2008 7:58 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks Lee. That was a HUGE help.
Left by Jared on Sep 23, 2008 12:32 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
@Jared & @Ja thanks for reading!!! Glad it helped!
Left by Lee Brandt on Sep 23, 2008 1:50 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
worked for me, thanks
Left by JB on Sep 24, 2008 12:52 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Simple fix that worked great! Thanks!
Left by gtg on Sep 26, 2008 1:01 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
@JB && @gtg: I'm so totally glad this is helping you guys.
Left by Lee Brandt on Sep 26, 2008 2:11 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Awesome! Thanks, I have been looking for this for quite a while. You saved my sanity... for today. :-)
Left by Michelle on Oct 17, 2008 1:19 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks its work superb
Left by dare on Feb 04, 2009 1:28 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Worked great, I spent time doing the repair thing and it did not work..this did!
Left by George on Mar 06, 2009 11:42 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
I am so glad this is helping people.
Left by Lee Brandt on Mar 06, 2009 1:29 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Still does help. Thanks a lot!!!
Left by Serg on Oct 16, 2009 12:56 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Anyone have any idea what causes this issue?
Left by Quinx on Oct 21, 2009 2:38 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
thank you ! fix for me :-)
Left by Wellboy on Nov 03, 2009 9:00 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you so much.
Left by Midax on Apr 19, 2010 12:18 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Yes, Thanks... You. It is hard to believe this issue was so simply fixed. I have a little hair left for something else.
Left by Ed Braddy on May 23, 2010 7:16 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you, Sir. It did solve my issue as well.
Left by SM on May 24, 2010 1:53 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
This worked straight away. Wow, thanks!
Left by JJFI on Jun 03, 2010 9:16 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
I am so glad this is helpful to everyone!
Left by Lee Brandt on Jun 03, 2010 9:19 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Awesome! That's the kinda stuff I like to hear! Glad it helped.

~Lee
Left by Lee Brandt on Jun 10, 2010 3:30 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you ,so much it fiexd to me..... :-)
Left by title on Jun 15, 2010 2:53 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
thanks for the tip!
it resolved my problem
Left by ssisboy on Jul 12, 2010 11:48 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
@Lee Brant. THANK YOU for posting this!!!!
Left by Andrew on Aug 27, 2010 7:26 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks, This is the first time I am commenting on any post. It helped me alot, was worked on this for a long time but now it is working :)
Left by Priya on Dec 10, 2010 1:57 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
You're a star. You just saved me an hour at work :)

Thanks
Left by Vijay Kanojia on Jan 12, 2011 4:05 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Glad this is still helping people.
Left by Lee Brandt on Jan 13, 2011 11:57 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you :) Came across this error today, and your solution solved the issue.
Left by Peter on Jan 21, 2011 3:23 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
still helping people!...this drove me cracked for a couple of hours until I came upon this link.
Many thanks
Left by coldsurfer on Jan 24, 2011 12:33 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Awesome!!! It worked at my end!!!
Left by RCV on Mar 16, 2011 11:07 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks Lee. It helped me today even after 3 yrs :) Wish I could treat you a cup of coffee :) More power.
Left by Catherine Sulit on Mar 28, 2011 2:50 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
WoW! This tip just keeps on helping!!
Left by Lee Brandt on Mar 28, 2011 2:52 PM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you for the clear and valuable tip which solved my problem
Left by Gopal on Jan 19, 2012 5:05 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thanks!!!! it works!!!!! :)
Left by crys on Feb 09, 2012 10:59 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank u so much, it really helped me!
Simple and efficient...
Left by Peter on Jan 09, 2013 5:17 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Work great for me, thank you.
Left by Chris on Mar 15, 2013 9:05 AM

# re: Creating SSIS Package Error
Requesting Gravatar...
Thank you!!

It Worked for me!! ;)
Left by Resistire82 on Sep 11, 2013 6:30 AM

Your comment:
 (will show your gravatar)


Copyright © Lee Brandt | Powered by: GeeksWithBlogs.net