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.