SSIS script task doesn't set variable when scheduled to run but works locally.

SQLServerCentral » Latest topics

SSIS script task doesn't set variable when scheduled to run but works locally.

I have a script that sets a variable to a date based on the files in a folder.

For example:

Variable: FileDate

Files:

  07062017ABCDog.txt
  06062017ABCDog.txt
  05062017ABCDog.txt

Here I

more info...