Need a task that will zip a file prior to upload via FTP

Need a task that will zip a file prior to upload via FTP

• kkaisa

   

  Duane Douglas wrote:

  you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx SiteID=68

  Thanks.  I posted the suggestion.

  
  

• BenRush

  Cool, thanks. I'll be looking for it to make its debut there.
  

• Donald Wm. Johnson

  Is there an eta for this
  

• AGuyTrying2

  Or use this: http://www.thejoyofcode.com/SSIS_Compress_File_Task.aspx

  -Jamie

  
  
  

• C10

  Excellent! Thanks. Will you be posting a link to it on your blog

  Cheers

  
  

• Ray1127

  We have built task for archiving in Zip, GZip, BZip2, Unix, Tar. We also have task for secure FTP (SFTP). You may give it a try here: http://www.cozyroc.com/
  
  Regards,
  Ivan
  
  
  
  

• Mike Diaz

  Hi

  I am also looking for the same task, what solution have you adopted in answer of your problem

  
  
  

• Dyvel

  Al C. wrote:

  I have a text file I need to zip (compress) before uploading it via an FTP task. Do I have to use a third-party tool to do this Thanks.

  you can suggest that this feature be added here: http://connect.microsoft.com/feedback/default.aspx SiteID=68
  
  
  

• weather

  No I'm afraid not because it is Conchango's own intellectual property. I was more making the point that this can be done.

  Don't fret however, Darren tells me that he has built his own so look for it appearing on SQLIS.com soon enough.

  -Jamie

  
  
  

• DustinT

  We have written a SSIS Task to do this for you. It works rather nicely.

  -Jamie

  
  
  

• jackycn

  We purchased WinZip product with command line interface. I added an Execute Process task to run the WinZip and I pass the file name in the command line arguments. There are other products that can do the same I believe, such as PKZip.
  

• Muhammad Imran Taqi

  Thanks. It looks like that task compresses into gzip format. I need the same format as when you do a right-click > 'Send to compressed (zipped) folder' via Windows since we send the file to clients who expect that format.
  

• Unni Ravindranathan - MSFT

  id gues you need a 3rd party piece of software for this. we have used PKZip exe here. its a simple command line app, so you can easily call in in a script task and get it to do its thing. there could be an easier way though...
  

• Frank Srebot

  I haven't found a task for this on sqlis.com or anywhere else yet, have you
  
• Need a task that will zip a file prior to upload via FTP