Hi,
I'm looking for a good data encryption tool which can be run from within a
DTS package (and therefore probably must have the capability of being run
from the command line). The idea is to create a text file, encrypt it, and
then FTP to a remote FTP site. Conversely, another package must pick up
file from FTP site, unencrypt it, and then continue to load into SQL Server.
I work for a public agency and cannot use freeware or shareware encryption
tool, it must be purchased.

If anyone is doing this or knows of some good encryption tools that can be
run in this way, please let me know.

Thanks.

I worked at a couple of places that used PGP to do the same
thing. www.pgp.com

-Sue

On Wed, 21 Apr 2004 22:51:42 GMT, "nji"
<innis1 (AT) sbcglobal (DOT) net> wrote:

Yep same here. PGP was used at a place I used to work. I also use it to
transport sensitive data via the cmdline interface.

Allan

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

We use Whamware.Crypt (www.whamware.com). They don't have a command line
interface, but we use both the COM and SQL Server editions of their product.

"nji" wrote: