Home Forums SQL Server 2005 SQL Server 2005 Integration Services Creating Header AND Footer to a flat file destination file RE: Creating Header AND Footer to a flat file destination file

  • November 28, 2012 at 12:08 pm

    #1563377

    sharon.poirier (11/28/2012)

    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?

    Hi Sharon,

    You need to follow the lettered steps under step 3 to get this to work for you. Based upon you explanation, it seems like you are just putting the Variable name in the Header property of the flat file destination itself. In order to get to the expression editor for the header, you must be in the properties window for the Details Data Flow Task not the properties window of the flat file destination. Review the step by step again for steps 3a - 3d.

    Let me know if you are still having problems. You will not need to do this in a Script Task.

    John Dempsey