I have written a pkg to read a file from a directory on the DB server. I've created an ActiveX script to use FSO to determine if any files exist in the directory. When running the DTS pkg using the play button, the script will run ok however, when I use the dtsrun utility (within a Job) the pkg fails with "path not found" error. The id the job uses to run the package is an administrator on the DB server machine.
If anyone has any suggestions please let me know.
A portion of the code is attached below;
NOTE:
Code fails on line #3
Value of gvFileLocation is "\\SrvrName\\D$\CMSReporting\Data\AHT_Skilled"
Code:
1. set pkg = DTSGlobalVariables.Parent
2. set fso = CREATEOBJECT("Scripting.FileSystemObject"
3. set fold = fso.GetFolder(DTSGlobalVariables("gvFileLocation".Value)
If anyone has any suggestions please let me know.
A portion of the code is attached below;
NOTE:
Code fails on line #3
Value of gvFileLocation is "\\SrvrName\\D$\CMSReporting\Data\AHT_Skilled"
Code:
1. set pkg = DTSGlobalVariables.Parent
2. set fso = CREATEOBJECT("Scripting.FileSystemObject"
3. set fold = fso.GetFolder(DTSGlobalVariables("gvFileLocation".Value)