Hi,
I am using one SSIS package which contains one execute sql task and this task call one stored proc to return the 1000 rows around. I want to write all these rows to text file without any column info, but there will be one header and one footer information. The header should be like this Header CreateDate and footer should be like Footer Rows count.
So here the create date and rows count are dynamic.
Format like this
Header 26April2012
rows1,rows 2,rows3...........
rows..............
-------------------
Footer 1000(count of rows returned)
Please note.... i can not use the dataflowtask for this. My procedure get the final output through temp table and hence there is some issue.
I would like to use execute sql task..sript task..foreach lopp...
Please provide me the complete code...any help is appreciated