• Thanks John,

    Yes it helped tremendously and have successfully appended my footer to end of my detail file. I have another question with the header.

    In item #3 you refer to the header property of the flat file destination having an expression editor. I'm using ssis 2005 and don't have the espressions editor for the header property. If I put my variable there my file contains my variable name for the header.

    Can I access this property in my script task and assign it the variable? If so, how?