dbTalk Databases Forums  

call to a dts from a ASP

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


Discuss call to a dts from a ASP in the microsoft.public.sqlserver.dts forum.



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

Default call to a dts from a ASP - 05-04-2004 , 01:46 AM






Hello, I've got a problem.

I have a ASP page in a Server, and I want to make a call to a DTS that is
stored in other Server.

All the examples I have seen are making the call being the ASP page and the
DTS in the same server. Is possible to do what I want? How?

Thank you for your help.



Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default RE: call to a dts from a ASP - 05-04-2004 , 04:08 AM






Depending on the example, just change the server name and check the connection details in the LoadFromSQLServer call to load a package from another server.

Be aware that the package will then be executed on the web server under the urrent security context of IIS (IWAM_MACHINE) so it will need permissions to access the resources required by the package to execute.


"Javi" wrote:

Quote:
Hello, I've got a problem.

I have a ASP page in a Server, and I want to make a call to a DTS that is
stored in other Server.

All the examples I have seen are making the call being the ASP page and the
DTS in the same server. Is possible to do what I want? How?

Thank you for your help.




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.