Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Zip Task

Author  Topic 

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-09-30 : 06:18:52
Hi Guys

Is there a Task available that zips up files?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-30 : 06:34:14
http://www.sqlservercentral.com/articles/SSIS/64028/
Go to Top of Page

CodesMyBusiness
Starting Member

9 Posts

Posted - 2008-09-30 : 10:18:20
OR,
You could call cmdExec to call any freeware zip program.

You might want to write a stored procedure that takes in the file location, and preferred destination.

Just remember - It's synchronous, not asynchronous.
Go to Top of Page
   

- Advertisement -