Reading GZIP data through SQL Server 2000

• koustav_1982

  SSCommitted

  Points: 1788

  More actions

  June 10, 2008 at 9:47 am

  #121810

  My application is trying to pull the data through DTS from another application which stores XML data in GZIP fromat in ORACLE database

  Is it possible to read this data , decompress and then store in SQL tables in SQL Server 2000?

  IF so , then how can we achieve this

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  June 10, 2008 at 10:25 am

  #826803

  Go through the following link

  http://www.databasejournal.com/features/mssql/article.php/3556461

  Although this link is not for gzip but you can get an idea of how to use this compression utilities with sql server.

  Hope this helps.

  Manu