I'm new to SSIS.
I'm new to using Windows Authentication vs SQL Server Authentication.
Sorry, this is all going to sound terribly naiive.
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?
We need this SSIS package to continue to run even if my personal Windows login is closed, if I leave the company for example.
"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura