<div>
<div class="content wysiwyg-content">
I'm relatively new to SQL 2000 DTS and need to design a package that encrypts a dab-delimited file to PGP format.<br />
I'm wondering which encryption application would work best within SQL DTS Designer, and also how that would be implemented.<br />
<br />
Thanks in advance,<br />
jm
</div>
</div>


I'm relatively new to SQL 2000 DTS and need to design a package that encrypts a dab-delimited file to PGP format.
I'm wondering which encryption application would work best within SQL DTS Designer, and also how that would be implemented.

Thanks in advance,
jm

PGP Encryption in SQL 2000 DTS Package

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

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.