I am using a OLE DB desitination to load a SQL Server 2000 database table. The volume of the data is .38GB (2357536 rows). The package execution is taking more time to commit. The data tree shows that the data has been reached the OLE DB destination,
but not committing. I have set the DefaultBufferMaxRows to 10k as suggested in one of the post. Still my OLE DB destination is taking more time to commit. What could be the reason? Please help.
Thanks in advance
View Complete Post