Hallo,
i am having a problem to execute dts from asp.net page. The c# code
are similar as descriped in the cookbook from http://sqldev.net:
DTS.Package2Class pkg = new DTS.Package2Class();
object pVarPersistStgOfHost = null;
pkg.LoadFromSQLServer("(local)", null,
null,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Us eTrustedConnection,
null, null,null, "TestDTS",ref pVarPersistStgOfHost);
pkg.Execute();

i have turned off the annoy access in IIS and also changed the
identity in web.config: <identity impersonate="true"
userName="domain\myname" password="passwd"/>

But I got the exception:
Login failed for user 'machinename\ASPNET'

Could anyone tell me how to solve the problem?

Thank you in advance

jani