I need some assistance setting up a global variable that will be used to specify the path of a text file as my data source. I have accomplished this in the past, but cannot duplicate. In what order do I add the Dynamic Property and the Text File (Source) - or does it even matter?
Every time I set the data source value for the txt file within the Dynamic Properties task to use my global variable, it still retains the 'hard coded' Default Value which was required to add the Text File (Source) to my package in the first place. At the same time, after setting the Data Source to use my global variable, if I open the Text File (Source), the FileName is still hardcoded whereas it should be blank.