Using SSIS I want to encrypt a text file with a password. Do I need to use winzip to encrypt a text file by applying password? Or can I directly encrypt a text file without using winzip? Any ideas? Thanks. sqldev

You have several options for compressing files with/without passwords. You can use an Execute Process Task to run a command line utility like Winzip (the command line interface is only available in the paid version, I believe). You can use a third-party compression task like the free TaskUnZip, or CozyRoc's Zip, or /n's Zip. Or you can search on these forums, I think someone has posted instructions on how to make a Script Task to do this with .Net code. Talk to me now on

Here is an example of zipping with a Script Task: http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com