|
Home > Archive > MS SQL Server DTS > September 2005 > Remote DTS execution
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Remote DTS execution
|
|
|
| Have a DTS package that will run on the server and through a job scheduled on
the server.
But when attempting to run it from a remote machine or an ASP page it fails.
On the ASP page I'm using
objDTSPackage.LoadFromSQLServer "Supersix3", "DTSexec", "DTSexec",
DTSSQLStgFlag_Defaul
t, "", "", "", " Law_Income_Statement
"
(can post all the code if needed)
I have limited the ASP page access via integrated security. I'm thinking
this is a permission issue on both aspects, both the web page and remotely
via EM.
Thanks,
| |
| David J. Cartwright 2005-09-23, 1:23 pm |
| try executing job, not package
"Chad" <Chad@discussions.microsoft.com> wrote in message
news:EE0FDEEC-04E0-49A8-8EE7- 8604379E3D8A@microso
ft.com...
> Have a DTS package that will run on the server and through a job scheduled
> on
> the server.
> But when attempting to run it from a remote machine or an ASP page it
> fails.
> On the ASP page I'm using
>
> objDTSPackage.LoadFromSQLServer "Supersix3", "DTSexec", "DTSexec",
> DTSSQLStgFlag_Defaul
t, "", "", "", " Law_Income_Statement
"
>
> (can post all the code if needed)
>
> I have limited the ASP page access via integrated security. I'm thinking
> this is a permission issue on both aspects, both the web page and remotely
> via EM.
>
> Thanks,
| |
| Allan Mitchell 2005-09-24, 7:23 am |
| And what is the error?
Allan
"Chad" <Chad@discussions.microsoft.com> wrote in message
news:EE0FDEEC-04E0-49A8-8EE7- 8604379E3D8A@microso
ft.com:
> Have a DTS package that will run on the server and through a job scheduled on
> the server.
> But when attempting to run it from a remote machine or an ASP page it fails.
> On the ASP page I'm using
>
> objDTSPackage.LoadFromSQLServer "Supersix3", "DTSexec", "DTSexec",
> DTSSQLStgFlag_Defaul
t, "", "", "", " Law_Income_Statement
"
>
> (can post all the code if needed)
>
> I have limited the ASP page access via integrated security. I'm thinking
> this is a permission issue on both aspects, both the web page and remotely
> via EM.
>
> Thanks,
|
|
|
|
|