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
466 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.

749 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