MaxInsertCommitSize - SQL Server Destination

Installing SP1 for SQL Server 2005 should get this property ? I am not able to get the same even after installing SP1

Can Anybody guide me here ?

This isn't an option on SQL Server destinations. Use the "Fast Load" option of OLE DB Destinations instead.|||Thanks for the comments Phil, so does this mean that there is no way I can specify a batch commit size. can i do some sort of error handling in SQL Server Destinaton ?|||

MShetty wrote:

Thanks for the comments Phil, so does this mean that there is no way I can specify a batch commit size. can i do some sort of error handling in SQL Server Destinaton ?

Using a SQL Server destination does not perform any error checking. It assumes that the data types are correct, keys will not be violated, etc... If you want to be able to redirect rows that fail on insert for one reason or another, use the OLE DB Destination instead. SQL Server destinations are designed to be super fast at the cost of data validation.