Post reply

Isi it possible to have a dynamic header row in a FlatFile Destination?

  • December 4, 2015 at 1:41 pm

    #309967

    I have a flat file destination and I'd like to add some dynamic values (date and time values) to the header. I don't see an expression ellipse in the destination properties. Is it possible to do this? Could I just paste a Variable with the text I need in the header box and it work?

  • December 7, 2015 at 8:53 am

    #1844410

    I'm 99% sure this cant be done with a standard flat file destination as the columns are actually bound in the connection manager rather than the destination for a start.

    You might be able to achieve it with a script component (even then I'm not so sure).

    The only option I can think of is to add a couple of "dummy" fields to the end of the connection manager and use them as needed (you'd have some blank fields when they aren't used). To do this you'd need to remove the header row option in the destination connection manager and then fabricate a row to add at the top of your dataset to add the column headers in that way.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply