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("DTS.Package"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
'objPkg.LoadFromSQLServer "783UIR", "sa", "", ,"","","","B2BDTS"
objPkg.Execute
For iCount = 1 To objPkg.Steps.Count
If objPkg.Steps(iCount).ExecutionResult = 1 Then
strError = strError + objPkg.Steps(iCount).Name + " failed. <br>"
End If
Next
If strError = "" Then
Response.Write "Success"
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
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("DTS.Package"
'objPkg.LoadFromSQLServer "783UIR", "sa", "", ,"","","","B2BDTS"
objPkg.Execute
For iCount = 1 To objPkg.Steps.Count
If objPkg.Steps(iCount).ExecutionResult = 1 Then
strError = strError + objPkg.Steps(iCount).Name + " failed. <br>"
End If
Next
If strError = "" Then
Response.Write "Success"
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