SSIS - SQL Job
-
Hi, I have created one SSIS Package and saved a copy of file as "Enrypt Sensitive Data with Password" Option and saved in file system. After that I have import package on SSIS server under MSDB folder. Now I have create one SQL Job and in steps select SSIS Package and I am having one Domain User Name and used PROXY account to run the job. Now the issue is that when I keep Server Console with login of the same Domain User Name, SQL Job is running fine daily... But when I logged off on machine then Job fails. Failed to understand the rights issue with Domain User Name. User is Power User group member of Machine and given rights as below as well. Log on as a batch job Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment But still facing issue when there is no session availble on server with that User. Please help !! Thankssssss
Thanks, Sun Rays To get something you must have to try once. Rate answers if you like else reply me so can make it liked.... My Articles