Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bryan42
Starting Member
28 Posts |
 Posted - 2007-06-27 : 15:52:01
|
| An existing DTS selects rows from various tables and outputs them to a CSV file. I need to use PGP (the command line version) to encrypt that output file. The catch here is that I'm required to do this without ever writing an unencrypted file.So, how can this be done? I haven't used xp_cmdshell or dtsrun.exe before.May I take the output of a stored procedure and send the results directly to PGP with xp_cmdshell? How does that work?Or, could I use one stored procedure to capture the output of a select statement and send all that to PGP with xp_cmdshell?Is there a way to use dtsrun.exe for this in DOS to pipe the output to PGP, then maybe include that in a DTS?thanks,Bryan |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-06-27 : 17:06:19
|
quote:
Originally posted by bryan42
The catch here is that I'm required to do this without ever writing an unencrypted file.
That's quite a catch. I would try calling your SP from osql.exe at the command line, and filtering that output through PGP, rather than doing this from within a DTS package.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-27 : 17:52:36
|
| Or create a view with encryption functiality over the columns and export the result from the view.Search for RC4 encryption/decryption here at SQLTeam.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
How to encrypt a file exported in DTS