Post reply

ZIP A .txt FILE BEFORE DOING MY FTP

  • October 24, 2008 at 1:38 pm

    #128089

    I have a requirement where I have to FTP a .txt file to my Users. NOW they want to compress the file size before doing FTP and send that zipped file. I know there is a way to do it. BUT HOW?

    Can someone provide me suggestions, where to find the solution. Or post somelinks. I have tried using Winzip through Execute process Task but for SOme reasons it is failing. I pointed to that WINZIP32.EXE file and Passed my Arguments in varaibales.

    IS there some scripts task that I can do to achive this?

    Or there is other way to do it?

    Any help is higly appreciated................

  • October 24, 2008 at 1:42 pm

    #889452

    Have you read this

    http://www.sqlservercentral.com/Forums/Topic482799-148-1.aspx

    Read All the way below

    http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1149752&SiteID=17

    I was able to zip mine using winzip command line and wrote some code in Script Task to call winzip command line and pass the arguments

  • October 24, 2008 at 2:06 pm

    #889467

    Hey I went through all....Couldn't figure out................ALl this talks about Unzipping the file. In my case I need to ZIp it..........ans then send it through FTP.

    SO in my case .........I need to ZIp a text file and FTp that to another server..............

    DO u have ur solutions , Can u please post it here or email me.......

    Help will be really appreciated............

    thanks

  • October 24, 2008 at 2:08 pm

    #889469

    Check the Zip Task. It is very easy to use.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 24, 2008 at 2:28 pm

    #889477

    Not sure how big you files are but this as an Open Source

    http://www.sqlservercentral.com/articles/SSIS/64028/

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

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