ssis security

  • Hi, we are saving passwords for all our packages in an xml file which is not very secure, is there an option to save them to a database table or any other method so passwords are not visible to every one and also want to make sure pkg works fine when deployed on the server. Thanks

  • I store my SSIS passwords in a third party password manager, along with the rest of my database related credentials for service accounts and any SQL authenticated logins.  I keep that program's data file in a place only the system admins can get to.  The only problem with deploying the package to the server is if it's scheduled in a SQL Agent job, the password you enter for the job step will be visible in plain text in the MSDB.dbo.sysjobsteps table, so make sure you restrict access here.

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

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