The package contains two tasks: one is truncate the SQL table (the SQL Server was initially 2005) and the other is to load data from Oracle to SQL. The package executes successfully. However, only partial data have been written. To be specific, there are more than 5 million records in Oracle table but only 3 million records were written to SQL table.
Connection Managers have correct connection strings pointing to correct SQL and Oracle databases.
The Maximum insert commit size property of the OLE DB destination "component "OLE DB Destination is set to 0.