Flat File Header

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » Flat File Header

Flat File Header

Topic RSS Feed

Posts under the topic: Flat File Header

Posted: 1/3/2012

Jedi Youngling 14  points  Jedi Youngling
  • Joined on: 12/14/2011
  • Posts: 7

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

 

 


Posted: 1/3/2012

Jedi Master 5325  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 298
Page 1 of 1 (2 items)