Solved

Can you decode an encripted .csv file for ETL in SSIS then after transformation encript again to a .csv file?

Posted on 2013-05-29
1
463 Views
Last Modified: 2016-02-10
Hi Experts,
I would like to know if it’s possible to use SSIS to decrypt a .csv file, do the transformations e.g. change to correct date format etc. Then export again into an encrypted format.

At moment I don't have complete details about how the file is encrypted but I just want to know if there is some way in SSIS to do this?

I am using SQL2008R2.

Many thanks,
C
0
Comment
Question by:bruskhickory
1 Comment
 
LVL 23

Accepted Solution

by:
nemws1 earned 500 total points
ID: 39208971
I think the answer is yes.  You would have most likely have to call an external program to do the decryption/encryption.  I did this with PGP at my last job.

As a caveat though - we were okay with having a decrypted version of the text file on the local filesystem.  That may be a caveat you're not okay with.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question