Writing output to text file

• Karan_W

  Ten Centuries

  Points: 1326

  More actions

  April 25, 2012 at 10:49 pm

  #259977

  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

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  April 27, 2012 at 5:58 am

  #1480324

  Why exactly can't you use the dataflow?

  If you run the sp in the OLE DB source, doesn't it return the rows needed?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP