Query to File

• achowe

  SSCrazy

  Points: 2075

  More actions

  March 24, 2005 at 5:25 am

  #87874

  Query Analyser - Query To File - Is there a way of specifying in code the filepath/name where a query is saved to, rather than using the prompt that appears when you run the query?

   

  Thanks guys

  
  If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

• Martin D. Cymerman

  SSCrazy

  Points: 2079

  More actions

  March 24, 2005 at 5:35 am

  #548703

  Take a look at:

  http://www.extremeexperts.com/sql/scripts/SaveOutput.aspx

• J M Davis

  Grasshopper

  Points: 13

  More actions

  March 25, 2005 at 9:05 pm

  #549036

  I'm new here but wouldn't it be easier to make a dts pkg with your query and output to file from there?