question

artistlover avatar image
artistlover asked

Using stored procedure in ssis and data flow task.

I bring in some passwords from access. I'd like to encrypt the passwords before pushing to sql server anyone know of a way to do this. I can run the stp after i transfer. I know how to do that but i'd like to do it before i push data into sql.
ssis
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

eghetto avatar image eghetto commented ·
What's the meaning of 'stp'?
0 Likes 0 ·
artistlover avatar image artistlover commented ·
stored procedure.
0 Likes 0 ·

1 Answer

·
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered
If using SSIS, you can make use of a Script Component in the Data flow task and write a C# or VB.Net code to handle the Encryption and Decryption. More reference [here][1] If Using T-SQL code, you can use the Crytographic Functions EncryptByKey & DecryptByKey for Symmetric Encryption and Decryption processing. These functions are supported in versions of 2005 and above. More reference [here][2]. Hope that helps! [1]: http://microsoft-ssis.blogspot.in/2011/09/encrypt-column-data-in-ssis.html [2]: http://technet.microsoft.com/en-us/library/ms173744.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.