Tuesday, May 08, 2012 9:21 PM
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.
Tuesday, May 08, 2012 9:32 PMModerator
lot's of zip solutions:Or search this forum for more solutions. See related topics ------------------->
- Edited by SSISJoostMicrosoft Community Contributor, Moderator Tuesday, May 08, 2012 9:34 PM
Tuesday, May 08, 2012 10:16 PMwe 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.
- Proposed As Answer by sharma anil Wednesday, May 09, 2012 1:36 AM
Wednesday, May 09, 2012 1:40 AM
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/