Home Forums Data Warehousing Data Transformation Services (DTS) unzip files using DTS RE: unzip files using DTS

  • April 13, 2005 at 8:21 am

    #552424

    gzip is free.

    exec master.dbo.xp_cmdshell 'gzip -d ... file'

    exec master.dbo.xp_cmdshell 'bcp ... file'