autoexcrement (8/8/2014)
If IT has set up a "Proxy Account" for me, how can I set up my SSIS package to use Windows Authentication but use that Proxy Account, instead of my own personal account which I use to log into the server?
In the job step you setup, there's a line called Run As: (or something similar enough). Pick your proxy there.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA