dbTalk Databases Forums  

Re: How can I encrypt DTS output automatically???

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


Discuss Re: How can I encrypt DTS output automatically??? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Juan
 
Posts: n/a

Default Re: How can I encrypt DTS output automatically??? - 07-01-2003 , 07:58 AM






Allan, the encrypt step is done from SQL?. If it is the case how do you do
it?. I haven't found anything in SQl's documentation.

Thanks, Juan.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
OK

I am still not clear where the encryption happens but what I do with Text
files is this

Export
Encrypt
Mail



--


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

"Juan" <juan_mauricio_lopez (AT) hotmail (DOT) com> wrote in message
news:OYirJ3#ODHA.3768 (AT) tk2msftngp13 (DOT) phx.gbl...
Thanks Allan. Looks like I didn't make myself very clear...

I have a sytem that reads ESN, once a certain amount of reads is
performed
I
have a DTS that exports them to an Excel file and then sends the file
trough
email. I need to automatically include an encryption step so the Excel
file
is sent already encrypted...

Juan.




"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:erhOfq#ODHA.3664 (AT) tk2msftngp13 (DOT) phx.gbl...
Use PGP Command line and use the Execute Process task to issue the
command.

--


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

"Juan Mauricio López G." <juan_mauricio_lopez (AT) hotmail (DOT) com> wrote in
message
news:uSymFe#ODHA.1072 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
I need to identify a solution to encrypt an excel file (using PGP)
generated by a DTS so it can be send trough email. How can I do the
encryption pat?.

Any help is very welcome. Thanks. Juan.











Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.