Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS permission!! Urgent Please

Status
Not open for further replies.

durug

Technical User
Mar 22, 2002
335
CA
Hi everybody!

I have this code that runs the DTS package(located on computer X) from a webpage located on computer Y.

<%
Dim objPkg, strError, iCount
'Create and Execute the package
Set objPkg = Server.CreateObject(&quot;DTS.Package&quot;)
'objPkg.LoadFromSQLServer &quot;783UIR&quot;, &quot;sa&quot;, &quot;&quot;, ,&quot;&quot;,&quot;&quot;,&quot;&quot;,&quot;B2BDTS&quot;
objPkg.Execute
For iCount = 1 To objPkg.Steps.Count
If objPkg.Steps(iCount).ExecutionResult = 1 Then
strError = strError + objPkg.Steps(iCount).Name + &quot; failed. <br>&quot;
End If
Next
If strError = &quot;&quot; Then
Response.Write &quot;Success&quot;
Else
Response.Write strError
End If
Set objPkg = Nothing
%>

If the webpage is on computer X (where the package is) everthing goes well. But if the webpage is on computer Y then the code from above can not execute the DTS package. Is there any permission settings that I didn't configure?

Thanks a lot!
Durug
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top