July 16, 2017 at 1:37 pm
I am new here and this is my first post. If I post this in the wrong forum, please let me know.
I have just created an SSIS package and was able to hook it up to a SQL Server Agent Job. In the tutorial, it showed me to create a Proxies account. What exactly is a proxies account?
Also, is there a SSIS tutorial for each of the controls in the toolbox? I know the basic of SSIS but would like to beef up on becoming advance level.
I am using the SSDT for Visual Studio 2013 shell. I think there is a new one for Visual Studio 2015.
July 16, 2017 at 4:28 pm
A SQL agent job will usually run under either the SQL Agent Service account (if the job owner is a sysadmin) or under the job owners account.
In best practice the account which the SQL Agent service runs under should be configured using the Principle of Least Privilege.
A proxy is then used to elevate the permissions to allow a job to do something which the service account or the owner account doesn't have permissions to do.
Look at signing up for visual Studio dev essentials - this gives access to puralsight who have some good SSIS courses. Check out the Microsoft Virtual Academy as well.
July 17, 2017 at 11:08 pm
Thank You
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply