SSIS - Zip and SFTP

[drampall]

HI,

Does anyone know which tools can be used with SSIS to
1. zip/unzip files
2. SFTP files?

SSIS gives the possibility to FTP files but not Secure FTP.
Has anyone been able to work around this?


Rdgs

David

 

[fuzzyocelot]

You can probably use something like WinZip to zip/unzip files. I'm pretty sure you'd have to purchase it in order to use the command line interface, though.

You will probably also have to go with a third-party tool in order to send files using secure ftp. We use WinSCP3 which is free and works pretty good for us.

I hope that helps!

 

[AlexCuse]

The System.IO.Compression namespace can be used to zip/unzip files

Here's a starting point:

http://msdn2.microsoft.com/en-us/library/system.io.compression(vs.80).aspx

There is also a free 3rd party tool called SharpZipLib that makes zipping/unzipping in .net very easy

http://www.icsharpcode.net/OpenSource/SharpZipLib/

if you wanted to go that route.

Hope this helps,

Alex

[small]----signature below----[/small]
Who are you, and why should I care?
Side A: We're a community of outdated robots who refused to upgrade and came here
*changes sides*
Side B: to live a simpler existence. Free of technology.