Groups | Blog | Home
all groups > sql server dts > april 2004 >

sql server dts : Data encryption software run from within DTS package


nji
4/21/2004 10:51:42 PM
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.


Sue Hoegemeier
4/22/2004 12:07:48 PM
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"
[quoted text, click to view]
Allan Mitchell
4/22/2004 7:16:39 PM
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


[quoted text, click to view]

TomO
4/24/2004 12:26:54 AM
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.

[quoted text, click to view]

AddThis Social Bookmark Button