Access to the path ... is denied. (DTSInstall)

• aniccadhamma

  SSC-Addicted

  Points: 455

  More actions

  November 14, 2010 at 10:39 am

  #141434

  I am getting this error when I attempt to run the Package Installation Wizard by double-clicking the manifest file. Wizard Launches, but aborts with:

  TITLE: Package Installation Wizard

  ------------------------------

  Could not create the directory "c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Packages\Data Flow". Access to the path 'c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Packages\Data Flow' is denied.

  ------------------------------

  ADDITIONAL INFORMATION:

  Could not create the directory "c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Packages\Data Flow". Access to the path 'c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Packages\Data Flow' is denied. (DTSInstall)

  ------------------------------

  Access to the path 'c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Packages\Data Flow' is denied. (mscorlib)

  What user needs permissions to this directory in order to give DTSInstall the access it needs to run the wizard?

  I have tried giving full acces to the following:

• sa
• SQL2005DTSUser$ACERNEDA
• TrustedInstaller

I don't even like to think about giving full access to "everyone".:unsure:

Thanks,

Neda