Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How do i add jobs of remote database without sqlagent login roles, currently i have sa password of the server and created SSIS packages using sa user, but same package dont run in SQL Server Job, how do i get around this.
i heard something called proxies in MS SQL server will do this!. looks difficult
(currently achieving this with windows task manager and SSIS batch files)

given is:
Server Sa User password is available
SSIS Package runs smoothly if manually executed.
Limited rights with windows authetication.
SQL server Agent available at client machine.
local DB Jobs runs Smoothly.
Posted

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900