SSIS 2008: Encrypt and Insert set of data within SSIS

Hi All

I have a set of data extracted from an XML file that looks like this.  Good so far. ee-xml-set-normalized-good.gifQuestion:  How to you encrypt + insert a set of data into a destination?  The T-SQL is belowee-destination-encrypted-schema.bmpMy requirements involve
Not saving any un-encrypted names and emails to a table
Inserting a set, not just one row

Thanks in advance.
LVL 66
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAsked:
Who is Participating?
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Figured it out...

Created a SP out of the above T-SQL to insert all rows encrypted.

Derived column task to transform data types into what SQL expects, and an OLE DB Command that passes as parameters all transformed columns.
Data FlowOLE DB Command, SQL Command
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.