Post reply

How to maintain the encrypted password in SSIS XML configuration file

  • October 23, 2011 at 11:37 pm

    #250593

    Hi All,

    How to maintain the encrypted password in SSIS XML configuration file ?

    Thanks & Regards

    Deepak

  • October 24, 2011 at 3:17 am

    #1398554

    If I understand your issue right:

    Setting the Protection Level of Packages

    Long story short: Either use Encrypt With User Key, and edit/execute the package/configurations only with a single user, or use encrypt with password. For execution, you can let SQL Server store the username and password for you, but keep in mind to set the protection level each time you update the package on your server.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

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

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