SQL Server Developer >> Unable to Create Object by using WScript.shell
Hi
I have a DTS which uploads a file to Secure FTP server. I'm using ActiveX
script to upload the file using scp2 command. I'm using WScript.shell to run
the command. When I manually run the DTS through the DTS designer it runs ok
but when I schedule the DTS as a job it fails at this point where I'm using
WScript.shell saying that the user is unable to create object.
Any help will be appreciated.
Error:
---------------
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
string: Error Code: 0 Error Source= Microsoft VBScript runtime error
Error Description: Permission denied: 'CreateObject' Error on Line 29
Error source: Microsoft Data Transformation Serv. The step failed.
-----------------
> Hi
> I have a DTS which uploads a file to Secure FTP server. I'm using ActiveX
> script to upload the file using scp2 command. I'm using WScript.shell to run
> the command. When I manually run the DTS through the DTS designer it runs ok
> but when I schedule the DTS as a job it fails at this point where I'm using
> WScript.shell saying that the user is unable to create object.
> Any help will be appreciated.
> Error:
> ---------------
> DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
> DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
> string: Error Code: 0 Error Source= Microsoft VBScript runtime error
> Error Description: Permission denied: 'CreateObject' Error on Line 29
> Error source: Microsoft Data Transformation Serv. The step failed.
> -----------------
>
> Thanks Riz