Error: COM object is either not valid or registered.

[Guest]

Hi Guys,

Paradon my ignorance on this issue.

I've done up a simple VB.net windows application which when executed from a
client PC, is suppose to execute a DTS job on my server.

When I implemented and executed the application to my client, I get this
error message "COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5}
is either not valid or not registered."

I've installed the RunTime Callable Wrapper in the Global Assembly Cache of
my client PC as per the KB article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;328587)

However the error still occurs and I've no idea why. Below is a sample of my
code

"Imports DTS
Imports System.Security.Permissions

Public Class Form1
Inherits System.Windows.Forms.Form...

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Label1.Text = "Status: DTS Import In Progress"
Label1.Update()
Label2.Text = "Starting Button Event"
Label2.Update()
Dim pkg As DTS.Package
Label2.Text = "Declaring DTS Variable"
Label2.Update()
pkg = New DTS.Package <--- Error encountered here"

Could anyone be kind enough to advise me or point me to the right directions
on this error? Many thanks in advance!!!

 

[Guest]

The class id specified in your error message is the class id of one of the
DTS COM components. The DTS COM components must be registered on your client
machines as well using regsrv32.exe (it is not sufficient to register the RCW
without the COM components). The file redist.txt located on the installation
CD of SQL Server contains a list of the files of SQL Server that you are free
to distribute.

HTH, Jakob.