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
460 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now