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?