Hi Phil, do you think its better to use Row count transformation and take the counts into variables first ?

Thanks

Phil, can you please give me the exact code the for the script task ?

yes ONLY the counts and not the data but the csv output file should contain the below fields.

FileName  Count

Thank you

HI , Can any body give me a step by step approach on building this package, that would be really great.

As i am a newbie to SSIS, i am not...

HI SSC, that should not be a problem...

Well, i mean there are 28 different flags in my source table..i dont mind how many times the package hits that table..

Ok. That is fine SSC. I will try on my own first..

HI guyz, can you please do those changes to my package which

i have attached, if possible ?

Thanks

Thank You Very Much for the suggestion Tim, but is it not possible to create the package without defining multiple flat file destinations as I have 28 different flags.

I...