SSIS package to run under windows authentication
I have some SSIS packages deployed on server with windows authentication (my user account) using protection level as ServerStorage. Also SQL admin has created jobs t开发者_如何学Co run these packages, admin account is the owner of all the jobs. The jobs are running fine till date but now since my work is over my account will be deleted from AD and I am not sure whether the packages will work or not thru jobs. It would be great if you can help me understanding the impact.
It's really hard to know without knowing the full scope of what your packages do.
If the admin account has rights to everything your account does, then it probably will be OK.
However, if the packages access files on a network share and the SQL admin account is a local account - you'll have problems.
If the package does anything with linked servers and the account is not able to get to linked server - you'll have problems.
精彩评论