SSIS access permissions

• Minnesota - Viking

  Hall of Fame

  Points: 3469

  More actions

  June 29, 2011 at 10:40 am

  #243388

  I am confused between the two ways of allowing access to users on SSIS. How are the following two are different ?

  Modifying security for My Computer and adding a user over there and

  Modifying properties of DCOM config -->Msdtssrvr and adding user over there ?

  Attached are screenshot.

  Thanks

  any MSDN reference would be great.

  [font="Verdana"]
  Today is the tomorrow you worried about yesterday:-)[/font]

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  June 29, 2011 at 12:53 pm

  #1346153

  What kind of actions are being performed by the package ? Would they actually need to be manually executed ?

  Do have service accounts for the package ?

  Jayanth Kurup[/url]

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  June 29, 2011 at 1:55 pm

  #1346213

  Why do users need any sort of SSIS privileges?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel