Output Query & Stored Procedure results to Text File with Headers (Pipe Seperated )

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  November 4, 2013 at 5:41 am

  #279550

  Our users want a Dump of the SQL Data which could come by running Query and Stored Procedure every day to a text File.

  They will use these text files to load the data into Excel to do a reporting.

  The Text file should have the column header also.

  output to \etwork1\TextFiles\Order.txt

  select * from Orders where orderDate <= 11/1/2013

  output to \etwork1\TextFiles\JobTran.txt

  EXEC JobTransSp '11/1/2013'

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 4, 2013 at 5:51 am

  #1663786

  Have you tried using bcp or SSIS?

  John

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  November 4, 2013 at 6:23 am

  #1663791

  I tried bcp but it does not give a column headers just a data.

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  November 4, 2013 at 9:03 am

  #1663862

  Is there a way to get the column names of the query and stored procedure to text file.