Using Encription on dts

#1

Hello there

I've heard about Encripting the DTS, to secure the transfare.

Where can i declare it? and will it slow the transfare of data?

#2

It can be done via 3rd party tools.

Within the DTS Package, create your text file as normal, call 3rd party app,
then xfer.

PGP is popular. www.pgp.com

--
HTH. Ryan

"Roy Goldhammer" <roy (AT) hotmail (DOT) com> wrote

Quote:

Hello there

I've heard about Encripting the DTS, to secure the transfare.

Where can i declare it? and will it slow the transfare of data?

#3

I'd go with that. What I tend to do is;

Export to text file locally
Encrypt using PGP cmdline
FTP

The user on the other end then picks up the file and decrpts at leisure.

Allan

Quote:

It can be done via 3rd party tools.

Within the DTS Package, create your text file as normal, call 3rd
party app, then xfer.

PGP is popular. www.pgp.com

"Roy Goldhammer" <roy (AT) hotmail (DOT) com> wrote in message
news:uQCzKZcEGHA.1816 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Hello there

I've heard about Encripting the DTS, to secure the transfare.

Where can i declare it? and will it slow the transfare of data?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using Encription on dts

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using Encription on dts - 01-05-2006 , 01:10 AM

Re: Using Encription on dts - 01-05-2006 , 03:30 AM

Re: Using Encription on dts - 01-05-2006 , 03:33 PM