Hey All,

I am new to DTS so please bear with me.

I have a DTS that generates a txt file output. All the queries, export and
that jazz work fine. What I need now is to encrypt that exported file with a
public key. Right now I let the DTS generate the file then manually encrypt
the file. Any insight on automation.

I would like to schedule this package to run at night, but can't leave an
unencrypted file out on the server so my current process is to run it
(having file currently exporting to my local machine) then manually
encrypting and manually moving onto the server.

Thanks bunches for any assistance

If you want to do this in DTS then PGP has a cmdline interface and you can
call that using the Execute Process task

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"SqlWannaBe" <SqlWannaBe (AT) nycap (DOT) rr.com> wrote