Oct 14, 2019
Execute SSIS Package from SQL Agent Services with new user.
Execute SSIS Package from SQL Agent Services with new user.
Execute SSIS package from SQL Agent Service
1. Create user at Operating system level – Eg Username: SSIS
2. Create Credentials in SQL Server Management Studio: Create one new Credentials for SSIS Package 3. Create proxies at SQL Server Agent : e.g. Create one new proxies "ssisproxy" select SQL Server Integration Service and put credentials name as above created. 4. Run the following command in…
View On WordPress