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.

maximum transaction retention property ?

1)Have Transactional replication and wanted to know what was the maximum
transaction retention property for distribution database is
2Also i was looking at the properties and it says that the subscription
could expire or get dropped if not synchronised within 72 hours. So my
question here is under what condition would it expire and when would it get
dropped
Thanks
Please see my reply to your other post.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)