row count to add in header

Question

row count to add in header

chinni-652949

Default port

Points: 1425
More actions
September 4, 2008 at 6:20 pm

#131159

how to get row count to add to a header.Data flow task is in a for each loop and when the loop iterate the row will b added to flat file each time.
if i use overwrite option each record is overwriten since its in loop.When the package is executed secord time the new records are appended to old ones since we dont have overwrite option enable,but i dont need old records and also how to count rows to add to header ,i trid using row count but did not work
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 1

You may consider creating a new file outside of the for each loop enumerator, and then disabling the overwrite option during the loop section.

You would most probably have to increment the row count with a scripting task inside the for each loop, and insert this afterwards, or alternatively, count how much you are going to insert before entering the loop and adding this to the file prior to executing the loop.

~PD

chinni-652949 Default port Points: 1425 More actions · Answer 2

I placed a row count before loop.

Inside the loop each time loop executes records are added to the flat file when i can not use overite option ,when the package is executed for second time since we dont have overwrite the records are appended but i woul dlike to have new records not the previous ones...

any suggestions?

thanks

chinni-652949 Default port Points: 1425 More actions · Answer 3

I crested a staging table inside the loop and after the loop i used one more data flow task and loaded from tabel to flat file...

thanks a lot for ur help