I have a ssis package given by a developer that imports data from an oracle database to SQL server.
I setup a job running on this SQL server to run this package, it hangs, running forever.
But if I run this package separately on visual studio on the server, it is fine, if using the DTExec tool it runs fine too.
I use SQL server agent service account to run this package that stored in the file system.
The SQL agent account is a domain account.
I wonder why it failed, the strange thing is if I create a proxy account that uses the same domain account SQL agent service use, and run the package using the proxy account, it will work, why is that?
They are actually the same domain account.