• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

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
0
bruskhickory
Asked:
bruskhickory
1 Solution
 
nemws1Database 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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now