I need to Encrypt a data column so we are using the HASHBYTES 'SHA_256' Method via a SQL Server Stored Procedure. When we output this data column to a Flat File Destination, it is resulting in unreadable characters.
â_ Ç ›è%òIÙ 8!Í v ·z +Ie 7ª 9 ²
Is there something I need to do in the Advanced Editor of the OLE DB Source in order to get this to flow to the Flat File Destination, a simple pipe-delimited .txt file, so the encrypted ID in this case is readable. When we run via SSMS the output looks just fine. It's when it tries to Data Flow to the Flat File Destination via the SSIS Package that it's getting messed up and coming out looking really ugly.
çC "åˆÔ»ÈÈùB$ô Ó¿K[ˆžº ¥Ibä VQ
If there is a better way to encrypt the data coming from the SQL Server Stored Procedure rather than using HASHBYTES 'SHA_256', then I'm all in.
Thanks for your review and am hopeful for a reply.