Do I need admin access on my computer to Run or maintain an SSIS Package?

Charles Luk

Do I need admin access on my computer to Run or maintain an SSIS Package?

by Charles Luk » Thu, 19 Jul 2007 04:15:18

Do I need admin access on my computer to Run or manage an SSIS Package

if i dont have admin access on my computer, what functionality of SSIS i cannot use




Michael Entin - MSF

Do I need admin access on my computer to Run or maintain an SSIS Package?

by Michael Entin - MSF » Sat, 21 Jul 2007 05:16:19

You can design, debug and run SSIS packages without admin access.

The limitations for non-admin I can think about:

  1. Obviously, package has same permissions as user who runs it, so if you don't have access to a file or database, the package will not be able to access them
  2. You may not be able to schedule package, if you don't have appropriate permissions
  3. Admins can monitor all packages running on a machine by connecting to SSIS Service. Non-admin are only allowed to see packages they've started