RE: Encryption or DigitalID for Emails from DTS
From: Vikrant V Dalwale [MS] (vikrantd_at_online.microsoft.com)
Date: 06/25/03
- Next message: Dejan Sarka: "Re: Error 21002: [SQL-DMO] user 'username' already exist"
- Previous message: Ray Higdon: "SA password"
- In reply to: Doug Odegaard: "Encryption or DigitalID for Emails from DTS"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 25 Jun 2003 00:59:30 GMT
Hello Doug,
I think you should look for writing a custom COM component to
handle\decrypt the email
attachement and later call it from an ActiveX Script (ActiveX Task). This
way, you have better direct control in-case you need to make a change in
the future.
For a standard mail reader, you can write a COM VB6 component.
For custom decrypting, write it as a VB.NET or C#.NET application.
Call it from DTS as a command line task (Process task).
The advantage of using the .NET framework is that there are managed classes
available for all of the crypto APIs method calls.
Finally, as you have pointed out, you might wanna try the email command
line utilities
such as PGP and other similar technologies.
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.
--------------------
| From: "Doug Odegaard" <doug@intralogix.biz>
| Subject: Encryption or DigitalID for Emails from DTS
| Date: Mon, 23 Jun 2003 13:47:44 -0600
| Lines: 15
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <u0TWTBcODHA.1684@TK2MSFTNGP12.phx.gbl>
| Newsgroups:
microsoft.public.sqlserver.dts,microsoft.public.sqlserver.security
| NNTP-Posting-Host: 64.25.141.114
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.security:14125
microsoft.public.sqlserver.dts:35259
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| I am struggling with how to tackle sending a digitally signed and/or
| encrypted email with an attachment from DTS. A Microsoft engineer noted
to
| me earlier that the MAPI profile used by SQL Mail will not pick up the
| Outlook-capable items such as digital ids, etc. and I have since proven
that
| (also sent to sqlwish). Has anyone else run into this problem and found a
| solution? PGP command line process? My skill set is VB/VB.NET/T-SQL
| primarily but if anyone can throw me a bone I'd sure appreciate it. This
is
| for a HIPAA-compliant process for a hospital to send regularly scheduled
| emails with attachments from DTS.
|
| Thanks in advance for your help!
| Doug Odegaard
|
|
|
|
- Next message: Dejan Sarka: "Re: Error 21002: [SQL-DMO] user 'username' already exist"
- Previous message: Ray Higdon: "SA password"
- In reply to: Doug Odegaard: "Encryption or DigitalID for Emails from DTS"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
