WORKAROUND:
- Have the file created on a subfolder
- Created a windows scheduled task to zip the folder daily after the file has been generated and have the zipped file deleted by the end of the day, this way the filename will always be the same, and spotlight will be able to monitor it properly.
STATUS:
Enhancement request has been logged for condieration for a future release of Spotlight on SQL Server Enterprise
Enhancement ID: SOSSE-I-113