Using the SQL Agent proxy is how I managed to impersonate 1 account, but of course, not the other. I managed to write my own connection manager. I...

Thanks again for the response... I was afraid of that. I do see those other options. Limiting the package with MaxConcurrentExecutables=1 does seem to work, but at a...

Hi... thanks for the response. I've considered that, and in fact, my design takes this in to account such that, when the custom uses SQL credentials for at least...

Only the database is case sensitive.. FYI:

xp_logininfo 'MYDOMAIN\ALLUPPER' returns the following:

Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62

Could not obtain information about Windows NT group/user 'MYDOMAIN\ALLUPPER', error code...