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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2004-08-21 : 10:38:14
|
| Hello...We have a table where some sensitive data needs to be encrypted. Normally, this is done within our .Net app before the data values are passed to the Stored Proc. Recently, I have been given some data files that have been exported from our customer's systems. I need to import the data and I have written some DTS packages to do just that. However, I am struggling with the issue of having to encrypt the data on the columns that require it.I was thinking of creatimg some sort of .Net DLL and then instantiate that within my Stored Procs (being called by DTS)..but that sounds like a performance hit when I have thousands and thousands of rows to import. I was hoping to discover a way to handle this all within Sql Server. Does anyone know if that is possible?thanks - dw |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-08-22 : 13:02:24
|
| Have you thought of using PWDENCRYPT? |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2004-08-30 : 11:44:15
|
| Thanks for the suggestion. Normally, I could use this...but I need to match the existing password encryption routines that are already a part of the application that uses this database. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-30 : 12:03:53
|
| then i guess your stuck with a dll...i don't know if it would be faster, but maybe you could do it from .net. just make a kind of an interface to get the data encrypt it and insert it into a database.Go with the flow & have fun! Else fight the flow :) |
|
|
|
|
|
|
Encrypt some data via Stored Proc?