I am creating a header in flat file which is a destination. i want to pass the record count in the header.
I am creating an expression in the flat file connection manager properties. I am selecting 'HeaderRowDelimiter' in property box and experssion
i am dragging my count variable (r1) as (DT_WSTR, 12)@[User::r1]. But when i am executing the package, i am getting file as:
Somehow it does not giving me the value of record count. I gives me (DT_WSTR, 12)@[User::r1] at the top.
Any suggestions as how to solve this problem
See if this helps.