How we can zip text files via Integration service project?

Question

i created a package in SSIS 2005. this package export my tables from sql server 2005 to text files daily. on the other hand i created another package for uploading these text files to FTP site. but the size of my text files becomes bigger and bigger day by day. i have to zip them and after that upload to FTP. would u please advise me?

tnx in advance.

Answer 1

You can use an external script task in SSIS to call the command-line version of 7-zip (7zip.org). That will work to automatically zip your files. Similarly you can use the same technique to upload your files with the windows built-in ftp.