Click here to Skip to main content
15,940,921 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.

willington.d 5-Mar-13 0:09am    
What are all the steps are u following?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900