I am in the processing of publishing my application to the server for testing. I am executing a DTS package from my code (web application .net C#): SQL Server 2000 database is being used.
Package2Class package = new Package2Class();
"username", "userpw", DTSSQLServerStorageFlags.D
null, null, null, "DTS name", ref pVarPersistStgOfHost);
However it fails when trying to execute the line 'package.LoadFromSQLServer
()'. I have got this working on my local machine but when I publish it to the server I am get the following error::
Message: Invalid class string
Source: Microsoft Data Transformation Services (DTS) Package
I can execute the DTS Package in SQL Server 2000 with the user details and it works no problem.
I did find this KB article: http://support.microsoft.com/?kbid=288910
but am not too sure if it applies in my case. I say this as the server which this application is being run on has the following dll's registered on it:
dtsffile.dll, dtspkg.dll, dtspump.dll, axscphst.dll
As far as I was aware these are the files only required for redistributing to allow DTS packages to be run.
This is all new to me so apologies if this is an simple query with a simple answer which I have missed. Any suggestions?