ODBC error when executed by SQL JOB AGENT

2

I am getting an error when I try to execute my SSIS Package by the Job Agent.

If I run through Visual Studio it runs perfectly.

The error is:

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

This ODBC is an "IBM i Access for Windows ODBC data source".

I have try to put the packages running at 32-bit. Change some parameters in my connection (that is a project parameter).

Update:

I had to change my queries and work with openquery. Just a note, get attention to numeric columns because I was having problems with decimal values.

sql-server
ssis
etl
sql-agent-job
sql-agent
asked on Stack Overflow Jun 19, 2019 by Ricardo Castro • edited Oct 8, 2019 by Ricardo Castro

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0