BCP

• Jon Herd

  SSC Journeyman

  Points: 82

  More actions

  May 15, 2007 at 3:14 am

  #124055

  hello,

  does any one know if it is possible to put a getdate() function into an output

  bcp "exec transactions..Calldowntimesummary" queryout "c:\temp\downtimereport.csv" -Uxx -Pxxxx -Sxxxx-xxx -c -q

  so that \downtimereport.csv becomes \downtimereportgetdate().csv

   

  i am stumped

  thanks in advance for any help and advice

  newbie-ish

• bledu

  SSChampion

  Points: 12335

  More actions

  May 15, 2007 at 3:52 am

  #706436

  you might want to consider using

  • a batch file
  • script file
  • dts package (overkill)

  ---

  Everything you can imagine is real.