Post reply

Zip File

  • November 16, 2010 at 9:40 pm

    #104004

    Hi all,

    Is there any way to create zip file in file system from SQL server (TSQL Code)

    I have a XML and i have to zip it and to store into file system from Sql server .

    If this is possible please guide me

  • November 18, 2010 at 3:41 am

    #1252367

    Hi

    I suggest will be to use SSIS and a job to zip

    Anwar

  • November 18, 2010 at 3:45 am

    #1252368

    Get gzip and use xp_cmdshell to execute an os command to do the zipping.

    Could use other zip utilities but I tend to favour gzip.


    Cursors never.
    DTS - only when needed and never to control.

  • November 18, 2010 at 4:07 am

    #1252373

    duplicate post.

    follow this link for the more robust question, as well as code examples using 7zip:

    http://www.sqlservercentral.com/Forums/Topic1022139-5-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply