ROWCOUNT gets the values once the data flow task completes, so i added a sql execute task to get the number of records and then concatenated in expression of data...

Has anybody achieved the short cut to add 'HEADER' or 'FOOTER' to a flat file . Using rowcount i got the number of records written to file , and using...