Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

data loss when using SSIS package to load data from Oracle to SQL Server Expand / Collapse
Author
Message
Posted Monday, October 01, 2012 6:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 7:50 AM
Points: 1, Visits: 1
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.
Post #1366533
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse