Thursday, January 17, 2013

SSIS - SQL Server Agent Permissions

Creating SSIS Jobs that can access network resources
  1. Create domain user
  2. Grant access to network share
  3. Create Credential that references the domian user
  4. Add Proxy that references credential
  5. Assign the proxy to ssis execution system

sqlsolace : SSIS Credential & Proxy

No comments: