Export to flat file without extended stored procedure

• MSSQLBuddy

  SSCrazy

  Points: 2354

  More actions

  April 19, 2011 at 4:08 am

  #235018

  Hi All,

  Sorry if the query exists previously.

  I would like to transfer data from SQL Server to flat file by using only stored procedure.

  Please let me know on BULK EXPORT from SQL Server table to flat file.

  Thanks in advance

  Priya

  Regards
  Priya

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 19, 2011 at 7:46 am

  #1313348

  I don't think there is a way to do this without doing some CLR programming.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 19, 2011 at 4:56 pm

  #1313697

  Please don't cross post, it just fragments the conversation:

  http://www.sqlservercentral.com/Forums/Topic1095501-392-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato