Hello there, I have two identical agent jobs that run off the same proxy account.
One created under one account. Works fine,
The other is created under another account doesn't work
The package truncate a table, then pulls in data from an excel file.
Connection to the sql database is SQL Login, with saved password in the package.
They both run under the same proxy account, i cannot understand why one would work and the other doesn't.
BUT. The job that doesn't work is created by the same account that is under the Proxy account
Does anyone have any suggestions on what else i could check please.