saving SP output to CSV without using xp_cmdshell

• charl-571329

  Newbie

  Points: 1

  More actions

  December 4, 2007 at 11:59 pm

  #95545

  Hi All

  I need to write the output of a SP directly to a csv file. Doing so with xp_cmdshell is easy but I need to get around the security issues that come with xp_cmdshell. Does anyone have any ideas???

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  December 5, 2007 at 2:28 am

  #757260

  Using xp_cmdshell to issue SQLCMD, BCP or OSQL is the right way to go but I guess you wouldn't get the required privileges to do that.

  Other alternatives could be....

  1. OPENROWSET

  2. linked servers

  3. OLE Automation Objects

  4. CLR Assemblies

  --Ramesh
  

  ---

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  December 5, 2007 at 7:05 am

  #757319

  SSIS?

  ---

  N 56°04'39.16"
  E 12°55'05.25"