dbTalk Databases Forums  

Running DTS from ASP.NET with LoadFromSQLServer gives me ACCESS ERROR

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Running DTS from ASP.NET with LoadFromSQLServer gives me ACCESS ERROR in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Camel
 
Posts: n/a

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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.