SSIS Flat File Output - Is it possible to password protect / encrypt a file?

• lindsayscott23

  SSCrazy

  Points: 2339

  More actions

  February 20, 2017 at 9:40 am

  #321842

  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

• Phil Parkin

  SSC Guru

  Points: 247154

  More actions

  February 20, 2017 at 9:49 am

  #1929388

  lindsayscott23 - Monday, February 20, 2017 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

  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.

  ---