I have DTS containing ActiveX task. DTS runs fine on SQL server 2000.
But when I schedule it as SQL job, the SQL job is failed.
My other SQL jobs which do not contain ActiveX run okay.

Why SQL job can not run DTS with ActiveX?

Thanks for suggestions.

Hello Mike,

And what does this task do?

Have a look here

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

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

This ActiveX only checks if new files are found. Manually run DTS is fine.
But SQL job always gets failed. I listed ActiveX code here:
-----------------------------------------------------------------
Function Main()
Dim objFSO, strFullNm, objFolder, objFile, colFiles
Set objFSO = CreateObject("Scripting.FileSystemObject")

strFullNm1 = DTSGlobalVariables("gvFilePathRoot").Value & "bgcmsdata_sbt"
strFullNm2 = DTSGlobalVariables("gvFilePathRoot").Value & "wlica.txt"
strFullNm3 = DTSGlobalVariables("gvFilePathRoot").Value & "wlick.txt"

Set objFolder =
objFSO.GetFolder(DTSGlobalVariables("gvFilePathRoo t").Value)
Set colFiles = objFolder.Files

If objFSO.FileExists(strFullNm1) Then
DTSGlobalVariables("gvFileName").value = "bgcmsdata_sbt"
Set objFSO = nothing
Main = DTSTaskExecResult_Success

ElseIf objFSO.FileExists(strFullNm2) Then
DTSGlobalVariables("gvFileName").value = "wlica.txt"
Set objFSO = nothing
Main = DTSTaskExecResult_Success

ElseIf objFSO.FileExists(strFullNm3) Then
DTSGlobalVariables("gvFileName").value = "wlick.txt"
Set objFSO = nothing
Main = DTSTaskExecResult_Success
Else
Set objFSO = nothing
Main = DTSTaskExecResult_Failure
End If
End Function
-------------------------------------------------------------

"Allan Mitchell" wrote:

Do you get any errors?

--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com

"Mike Torry" <MikeTorry (AT) discussions (DOT) microsoft.com> wrote

Yes. Here is error message:
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: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
--------------------------------------------------

"Darren Green" wrote:

Hello Mike,

Could it be that this variable "gvFilePathRoot" contains a value that cannot
be seen by running the package in a job?


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