Posted: 1/3/2012
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:
(DT_WSTR, 12)@[User::r1]
1,store manager
2,customer representative
3,regional manager
4,shift leader
5,district manager
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
Thanks
See if this helps.
http://www.bidn.com/blogs/KeithHyer/bidn-blog/1990/adding-a-header-or-footer-row-to-a-fixed-width-file-using-ssis