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
I tried at home, all on the same PC, I had to add the LOCAL\ASPNET account into SQL

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();

And the error is ?

Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207,1)

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Camel" <guillaume.waser (AT) wanadoo (DOT) fr> wrote

The error is an authentication problem like "user unknown" .

My deduction is that when i use the code from a "windows process" it
provides my account to COM+ ='DOMAIN\MyMachine' which is logged in
SQLServer,

but from asp.net the account used is 'MyMachine\ASPNET' which cannot
be in SQL

I have tried the code on a machine where both SQLServer and Asp.net
are installed - It works only if I plug the 'MyMachine\ASPNET' account
in SQL...

Any Idea bout ? Is there a way to change accounts ?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message