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

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
bruskhickoryAsked:
Who is Participating?
 
nemws1Connect With a Mentor Database AdministratorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.