Unable to call dts package from web application

[sivainsearchof]

Hi,

It would be of great help if some one could guide me on the below.

I am trying to execute a DTS package created in sql server 2000 from a web application created in asp.net 1.1 using C#.

I tried the same code with a windows application and was able to execute.

The code that i had used.

DTS.PackageClass package = new DTS.PackageClass();
package.LoadFromSQLServer("ctsintdluhgd","hcdev"," flowers",DTS.DTSSQLServerStorageFlags.DTSSQLStgFla g_Default, null, null, null, packageName, ref pVarPersistStgOfHost);

package.Execute();

the same code works in windows application.

I had added the reference to the name space DTS(using dts)

(Note: I dont have proper previlage to call the package through a stored procedure so chose this method)

Would appreciate your help.

Thanks & regards,
Siva.

[kenobewan]

Here is an article that may help:
How to Asynchronously Execute a DTS package from ASP or ASP.NET