sql server query output in csv or xls format

• tvchandra

  SSC Rookie

  Points: 31

  More actions

  October 28, 2008 at 8:19 am

  #200402

  We wanted to automize the output of a sql server query to store it as .csv or .xls output in the specified location of c:\.

  Kindly help us out in sorting this issue out, so that we do not want any manual intervention of selecting options in T-SQL, as we want this to be done as part the query command.

  Thanks to all for this help!

• AnzioBake

  SSCarpal Tunnel

  Points: 4134

  More actions

  October 28, 2008 at 10:12 am

  #890769

  hi

  The simplest answer would be to use SSIS.....

  There are ways in SSIS to dynamically create the file names etc.

  Then create a job with the execution schedule you require