In the header option for flat file destination editor.. I have a header which looks like this " 1245 NEXT CUSTOMER 03022014 "
I want "03022014" which is date to be populated with the date that the package is run so for example it should have been 03042014 for today
Everything else does not change. Final output will be a header in a text file.
inputs and suggestions?