1

I have created on SSIS(2019) package. The package is selecting the data from oracles tables in writing it to a flat file (CSV). The package is working perfectly in visual studio (SSIS designer). But when we have created a SQL agent job based on the same package from SSIS catalog, the package is only writing partial data to flat file. Suppose there are 200K records and it is writing 150K Records to the file. There is no error at the logs. Anyone has any idea on this.

Improve this question

1 Answer 1

Reset to default
2

You may want to try to force the 32-bit runtime in Agent and try again. Note that if the row count matches, then it'll be a driver/runtime mismatch, if not, try to redirect error/truncation rows and capture what's being rejected. One final suggestion is to compare agent parameter values vs designer.

Improve this answer
New contributor
Sweet Corn is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks. It is working now. I have changed the OLDED driver from OraOLEDB.Oracle.1 to MSDAORA.1.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.