0
Answer

Executing DTSPackages from VB.NET on 64 bit Windows Server

Peter

Peter

16y
2.5k
1
Hi @all!

I have got an application developed on 32 bit Windows. This application controls and executes DTS Packages on a SQL 2000 Server. So far everything works fine.

Now this application should run on a 64 bit Windows platform. First i got an error
"Retrieving the COM class factory for component with CLSID {10030000-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154"

Registering the DTSPKG.DLL as a COM+ Application solved this problem, but functions do not return any values. The application already runs as 32 bit application on the 64 bit System.

The following code was executed:

Dim oDTSApplication As DTS.Application
Dim oPackageSQLServer As DTS.PackageSQLServer

oDTSApplication = New DTS.Application
oPackageSQLServer = oDTSApplication.GetPackageSQLServer("(local)", "sa", "test", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default)

Any hints?