SQL2008 64Bit: Scheduling a SSIS package via SQL Job and run as another user
We need to run a SSIS package as another network user and not the SQL Server Agent Service Account. I can only select SQL Server Agent Service Account from the runas list. Is there a way to add a network user to the list?
If not is there a way to run a SSIS packages from windows 2008 task scheduler?
Cheers
June 15th, 2011 3:17am
please have a look at this article..
Let us TRY this | Mail me
My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2011 3:33am
The job owner option can be tried. Try changing the job owner to the account the job needs to be run with. Check this
threadhttp://deepaksqlmsbusinessintelligence.blogspot.com/ Happy to help! Thanks. Regards and good Wishes, Deepak.
June 15th, 2011 5:26am