Hi Experts ,
I need to process a file and get the last record and then process it. The last line is like a footer record which i need to match with the rest of the file. I'm just trying to get a handle on the best way to do this,
I thought of storing the information in a record set destination etc, or maybe something similar,
Potentially SSIS might not even be the best tool for the job in this case, maybe a script task instead might be worthwhile.