Creating a flat file with dynamic header RRS feed

  • Question

  • Hi All

    I have a task to create a flat file text file with data from a sql database.  This is all pretty straightforward and works fine.  The SSIS package retrieves data and then imports it into a flat file destination.  The flat file destination filename is created dynamically from a variable that has been declared.

    However, there is a further requirement to include the file name (from variable) as the top/header line in the flat file.  I know there is a flat file property for header, however as far as i can tell it doesnt allow me to use a variable etc.

    Is there a way i can include this filename variable as the header to my flat files? 

    Thanks in advance.

    Monday, August 29, 2011 6:07 PM