I have read..to add a footer on a FlatFile destination, use a 2nd DataFlowTask with a Script Component as Source...OK, I'm there, but when I get to the Create Script window, I dont know what to do with it to create/modify footer. Can someone give me a sample script of adding "ENDOFFILE <cr><lf>" in a footer?

Got it. Create Output...mine is named 'OPFooter' Create Column...mine is called 'ColFooter' Modify Script: Public Overrides Sub CreateNewOutputRows() ' ' Add rows by calling AddRow method on member variable called "<Output Name>Buffer" ' E.g., MyOutputBuffer.AddRow() if your output was named "My Output" ' OPFooterBuffer.AddRow() OPFooterBuffer.ColFooter = "ENDOFFILE" End Sub