Can somebody explain this one to me please?
I have used the Get System File Name Step to create the field 'filename' and run my Transformation only to find the error: Microsoft Excel Output.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Field [filename] couldn't be found in the input stream!
When I preview the input to the Microsoft Excel Output step the field 'filename' is clearly the first field variable! What do I do please? I want to know what file was processed for posterity.