how to get row count value to destination file

hi,

I have a requirement in which i need to pull records from a table and load into destination flat file ..and at end of file it should display row count

for e: like this

" rowcount: 40 records" ..

i tried placing rowcount transformation in between source and flat file destination..i am able to get all records in file but unable to pull value of variable where i stored row count into that file...any suggestions on how to do that?

thanks


  • Edited by ssisguy 4 hours 33 minutes ago
September 10th, 2015 10:32pm

Hi,

I think after the dataflow task for pulling the records to Flatfile, you can add a Script Task on the control flow to append the count captured by variable in rowcount task to the flatfile. Make sure you set the scope correct for the variable used to capture count of rows.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 2:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics