I'm trying to run this dts via the sql job. i used vbscript to transfer files
to another server:


Function Main()

Dim objFSO
Dim folSource
Dim folDestination

folSource = "X:\BACKUP\datalive"
folDestination = "\\23.654.211.02\data"


Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.CopyFolder folSource ,folDestination , True

Set objFSO = nothing

Main = DTSTaskExecResult_Success
End Function

im getting this error:

DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error
string: ActiveX Scripting encountered a Run Time Error during the execution
of the script. Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0
(0) Error string: ActiveX Scripting encountered a Run Time Error during
the execution of the script. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp Help
context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string:
ActiveX Scripting encountered a Run Time Error during the execution of the
script. Error source: Microsoft Data Transformation Service... Process
Exit Code 1. The step failed.


==========


im using the same login in the sql agent with the owner of the job. but i
cant seem to run it via the job.. but when i manually run it via the dts. it
works.

please help..thank you in advance

Hello troubleD,


OK so if you are windering whether it is a perms issue then just because
you can execute the package from where you are does not mean it can be executed
on the server. X:\ may not exist from the server's point of view and remember
the package may not execute as who you think.

Have a look at this


http://support.microsoft.com/?kbid=269074



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi allan,

thank you for your help. based on the sql server agent, the password did not
get matched with that of the sql server manager service user domain account.



"Allan Mitchell" wrote: