Running DTS from ASP.NET with LoadFromSQLServer gives me ACCESS ERROR -
10-16-2003
, 01:41 PM
I use the following code (used in a lot of discussions), into a
windows form (and DTSRun, Enterprise Manager...) without any problems
But when I try it in the code behind of an asp.net web form (I try asp
also) I have an error in the log of my DTS
Regarding the first task in the DTS, it can be an MAPI.dll error (for
email), or an authentication problem on exe task or connection task
It seems that there is a difference between the "environment" that
makes a windows programme deliver something that an IIS application
does not...
If any idea, please help!!!
ps: the IIS web is not running on the SQL Server machine
DTS.Package2Class pack = new DTS.Package2Class();
Object pVarPersistSTOfHost = null;
pack.LoadFromStorageFile(
@"\\ip_address\_Release\LOT_EXTRACTEUR_REMORA.dts" ,
null,
null,
null,
"LOT_EXTRACTEUR_REMORA",
ref pVarPersistSTOfHost );
pack.LoadFromSQLServer(
"ip_address",
"user_id",
"password",
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default ,
"","","",
"LOT_EXTRACTEUR_REMORA",
ref pVarPersistSTOfHost );
pack.Execute(); |