can we compress any file throgh SQL Server

• phani31

  SSC Journeyman

  Points: 89

  More actions

  May 31, 2012 at 6:49 am

  #274847

  Hi,

  Can we compress any file throgh SQL Server

  - using bcp, xp_cmdshell?

  - using sql_cmd?

  - stored procedure?

  ex:- saving the query results into file

  bcp "select * from [Instance Name].DBNAME.dbo.TableName " queryout "G:\Report.xls" -c -T -x'

  Thank you so much, in advance

  Phani

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  May 31, 2012 at 7:13 am

  #1495194

  Phani

  Sure. If you have WinZip or another such utility installed, you can use xp_cmdshell, which you can also use for the COMPRESS command if you have the Windows Resource Kit. Alternatively, I believe that PowerShell will do compression for you.

  John

• phani31

  SSC Journeyman

  Points: 89

  More actions

  May 31, 2012 at 7:25 am

  #1495200

  Thank you John , let me try this