I am Extremely NEW to SSIS (I'm using v2010)
I have a csv file I've exported data into but the consumer of this file requires a footer record. Its just a static piece of text. "end_of_file"
The csv is set up to put any text value in quotes and the header record is no exception, it needs to be in quotes.
I've been online and attempted many different methods to no avail.
This is the last piece to finish this assignment. Any assistance is greatly appreciated.
Thanks in advance.