xml-oledb-command-sql-command.jpg

xml-data-flow-with-oledb-command.jpg

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
I have a set of data extracted from an XML file that looks like this. &nbsp;Good so far. <a href="https://filedb.experts-exchange.com/incoming/2013/09_w39/678938/ee-xml-set-normalized-good.gif" target="_blank" title="ee-xml-set-normalized-good.gif (39 KB)"><img alt="ee-xml-set-normalized-good.gif" class="file-block lazyload" style="max-width: 587px;" data-src="https://filedb.experts-exchange.com/incoming/2013/09_w39/678938/ee-xml-set-normalized-good.gif" /></a>Question: &nbsp;How to you encrypt + insert a set of data into a destination? &nbsp;The T-SQL is below<a href="https://filedb.experts-exchange.com/incoming/2013/09_w39/678944/ee-destination-encrypted-schema.bmp" target="_blank" title="ee-destination-encrypted-schema.bmp (402 KB)"><img alt="ee-destination-encrypted-schema.bmp" class="file-block lazyload" style="max-width: 716px;" data-src="https://filedb.experts-exchange.com/incoming/2013/09_w39/678944/ee-destination-encrypted-schema.bmp" /></a>My requirements involve
<div class="bullet">
Not saving any un-encrypted names and emails to a table
</div>
<div class="bullet">
Inserting a set, not just one row
</div>
<br />
Thanks in advance. <br />
Jim
</div>
</div>


ee-destination-encrypted-schema.bmp

ee-xml-set-normalized-good.gif

Hi All

I have a set of data extracted from an XML file that looks like this.  Good so far. Question:  How to you encrypt + insert a set of data into a destination?  The T-SQL is belowMy requirements involveNot saving any un-encrypted names and emails to a tableInserting a set, not just one row

Thanks in advance. 
Jim

SSIS 2008:  Encrypt and Insert set of data within SSIS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Encryption is the process of encoding messages or information in such a way that only authorized parties can read it. In an encryption scheme, the intended communication information or message, referred to as plaintext, is encrypted using an encryption algorithm, generating ciphertext that can only be read if decrypted. For technical reasons, an encryption scheme usually uses a pseudo-random encryption key generated by an algorithm. An authorized recipient can easily decrypt the message with the key provided by the originator to recipients, but not to unauthorized interceptors.

Encryption

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.