Following YouTube example, but mine does not work. My Execute SQL Task is not assigning the selected string to User::FileName variable.
After building, tried to debug by right-click, Execute ‘Get Excel file name’ task. Is this the best way to debug? I cannot run the whole thing because the User::FileName remains blank and get an error further down the code.
I expect ‘PensacolaCitySales_’ to be put in User:FileName.
1