SQL Server 2008 SSIS 32-bit using Oracle 11g 32 bit client to connect to Oracle 10gR2
The job actually runs and populates the destination tables correctly, but for some reason the agent reports the job as failing. there is only one step (the SSIS package itself).
The package execution returned DTSER_SUCCESS (0). The return value was unknown. The process exit code was -1073741819. The step failed.
There are many other packages that are built more or less the same that do not throw an error but for some reason this one does.
I know this isnt a lot of information - mostly hoping for tips on what steps I can take to narrow in on the problem.
I've run the package directly from Integration Services on the server as well as from BIDS on my desktop and it succeeds.
View Complete Post