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.