question

nisha1010 avatar image
nisha1010 asked

ETL ssis Excel to SQL column encryption

Hi , I am trying to load excel sheet in SQL server database and it has 5 columns 2 variables start date and end date . I want to encrypt one of the columns in the excel sheet while i load it in destination database . I have already created master key ,certificate,symmetric key. I want , Start Date and end date variable One column encrypted in database clear text column dropped rename newly ecnrypted column Record check What should be my process flow ?
ssisetl
3 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.

DaveC avatar image DaveC ♦♦ commented ·
Moved to the default space so question is visible.
0 Likes 0 ·
KenJ avatar image KenJ commented ·
I'm not familiar with excel variables, outside of VBA. Do you just have two additional columns for start and end dates or are there actual variables in play?
0 Likes 0 ·
JohnM avatar image JohnM commented ·
How many rows are we talking about here? And is it acceptable to land the data into a staging table (not encrypted) first and then move it to the final destination (encrypted)?
0 Likes 0 ·

0 Answers

·

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.