Post reply

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

  • 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

  • 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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply