CI-DS Global Variable override not working

[willsuus]

I have a CI-DS task where I have $G_FILE_NAME as a global variable. When running the job (as Run Now), I chose to enter an alternate file name than was set up with the task (using the Current Value (for this run only) functionality). But, when the task runs, it still uses the original file.

I do have the file name variable defined in the transformation and can also see it in the Execution Properties tab. I have had this work on other tasks that appear to be set up the same way. Am I missing some configuration within the task?

[balazsbence95 · Accepted solution]

Hi,

Suggest you print out the value of the global variable into the trace logs by using the print() function in the preload script to make sure you have the correct folder path given.

I tested this scenario and it worked for me.

Regards,
Bence

[willsuus · Accepted solution]

What you provided did help in verifying that the global variable override was working.

The issue was that when the source file was added to the data flow, the actual file name was used, not the global variable ($g_file_name).