Integration service problem

7 Sep 2007 2:36 PM

Peter Lux

I run a DTS on SqlServer 2005 to import a csv into a custom table that
imports data to Great Plains. The package was running fine last month and
was running fine till yesterday. I uninstalled C# 2008 "orcas" and now when
I tried to open the project, it says that, "An error prevented the view from
loading" and tells me, "Class not registered (Exception from HRESULT:
0x80040154 (REGDB_E_CLASSNOTREG))
(System.Windows.Forms)

This comes up regardles of whether I try to bring up this project or create
a new one. I thought something had gone "hinkey" with the uninstall, so I
uninstalled Integration Services in SS2005 and reinstalled. Rebooted and I'm
still getting the same error.

Any clues? Do I have to wipe framework 3.0, too?

I need to get these procurement card transactions posted to GP pronto!

10 Sep 2007 2:59 AM

Peter YangMSFT]

Hello Peter,

Thank you for your post!

I understand that you enconter "An error prevented the view from loading"
and "Class not registered (Exception from HRESULT: 0x80040154
(REGDB_E_CLASSNOTREG))(System.Windows.Forms)" when you run SSIS to import
CSV or creating a new project. This occurs after you removing C# 2008
"orcas" on the server. If I'm off-base, please let me know.

Based on my experience, this issue could occur if SQL client tools related
components have some corrupted registry keys.

I suggest that you remove/reinstall Workstation components of SQL 2005 via
Add/Remove programs, and re-apply the service pack such as SP2 (if you have
applied it already) to test the situation.

If you have any update, please feel free to let's know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================
Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.

If this response time does not meet your needs, please contact CSS for more
immediate assistance:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607