Unable to Create Object by using WScript.shell  
Author Message
dshan1061





PostPosted: Thu Mar 24 12:21:03 CST 2005 Top

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.
-----------------

Thanks Riz

SQL Server185  
 
 
rmartinez





PostPosted: Thu Mar 24 12:21:03 CST 2005 Top

SQL Server Developer >> Unable to Create Object by using WScript.shell You should apply more randomness :-)

select rand(id)* 100 ,rand(id * rand(25.4)) * 10 ,rand(id * rand(11.6)) *
1000 ,rand(id * rand(1220)) * 56
from otherTable





> 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