Solved

System runtime interop.services error running a DTS package from VB.NET 2005 app.

Posted on 2007-03-21
5
3,274 Views
Last Modified: 2013-11-30
I have a vb.net 2005 app that accesses a sql server.  We are using sql sqerver 2005 and the computers have windows xp sp2 on them.  When the app gets to a procedure that runs a dts package I get the following error:

System runtime interop.services.comexception (0x80040154):Retrieving the COM Class factory component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} Failed due to the following error: 80040154, at WindowsApplication1.frmMainForm.RunDTS(etc)

It works on my machine so I am assuming there is something that needs to be installed on the client machine.  Any ideas?
0
Comment
Question by:jamesrbarnes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:jef06
ID: 18769577
You might want to do a setup project it will, tell you all the reference needed, and install them.
0
 

Author Comment

by:jamesrbarnes
ID: 18770538
jef06,

I have installed it with a setup project and I still get the error.

Jim
0
 
LVL 5

Expert Comment

by:jef06
ID: 18770553
Did you install Sql Server Enterprise edition on that machine, it might be that if i remember DTS can be use only with that version. Not the express.
0
 

Author Comment

by:jamesrbarnes
ID: 18771435
No, I just installed express.
0
 
LVL 5

Accepted Solution

by:
jef06 earned 500 total points
ID: 18771462
That should be it. try on a machine with enterprise.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
wrapping text in datagridview header columns 1 28
Updating Printer Details in VB.Net 16 42
Creating a View from a CTE 15 45
T-SQL: Wrong Result 7 37
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question