Zipping file in SSIS

Question

Hi

I am creating a flat file in SSIS. After creating the file, i want to zip the file and then FTP it to the required destination.

Is there any way we can zip the file in SSIS. Please suggest the solution.

Thanks

Answer 1

lot's of zip solutions:
http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html

Or search this forum for more solutions. See related topics -------------------> 

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

we can use third party tools like winzip to zip the files in SSIS. Setup the Execute Process Task in SSIS  to execute winzip.exe and pass filename as argument.

Answer 3

Yes ,use the thrid party tools like 7-zip(which is freeware u download and used it) to zip the files.and the used Execute Process Task to execute 7zip.exe and pass the file name.

Go through this link http://dataintegrity.wordpress.com/2009/10/13/dynamically-zipping-files-in-ssis/