Security of package

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  September 26, 2008 at 11:32 pm

  #126524

  can we make a package such that when u open it it shud ask for an od password..

  Is it possible?

  thanks in advance

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  September 29, 2008 at 7:12 am

  #878377

  Have a look at this link

  http://blogs.conchango.com/jamiethomson/archive/2007/04/26/SSIS_3A00_-Storing-passwords.aspx

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 29, 2008 at 9:50 am

  #878476

  You'll need to set the protection level of the package to EncryptAllWithPassword or EncryptSensitiveWithPassowrd before saving it. See BOL: http://msdn.microsoft.com/en-us/library/ms141747(SQL.90).aspx

  Greg