Adding Trailer(RowCount) into existing Flat File using SSIS package

See more:

SSIS

Hello All,

I need to add trailer into existing flat file using SSIS packages.
Trailer should like : "TRL,<rowcount>"

I am using "Flat File Destination" component.I am facing problem adding "Rowcount".
I have tried using "Rowcount transformation", but I am getting error message as

"The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there."

Kindly suggest me ways of adding "Rowcount" into file.

Thanks in advance.

Regards,
Swati