February 20, 2017 at 9:40 am
Hi all,
I have an SSIS package that outputs a .csv file to a folder on an internal file share server. The file will contain sensitive customer information and will be generated each week so that a small team can access it.
My question is... Is it possible to add password protection / encryption to the .csv file as part of the SSIS process? If so... what is the best way to go about this?
Thanks loads for any help / guidance as ever!
Lins
February 20, 2017 at 9:49 am
lindsayscott23 - Monday, February 20, 2017 9:40 AMHi all,I have an SSIS package that outputs a .csv file to a folder on an internal file share server. The file will contain sensitive customer information and will be generated each week so that a small team can access it.
My question is... Is it possible to add password protection / encryption to the .csv file as part of the SSIS process? If so... what is the best way to go about this?
Thanks loads for any help / guidance as ever!
Lins
CSV files do not support encryption natively. However, I see no reason why you should not be able to add another step to your SSIS package which Zips up the file with a password.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply