MaxInsertCommitSize not found in SQL Server Destination

Hi,

I have installed SQL Server 2005 Service Pack 1 installed. I could see that from running @.@.Version command.

i am not able to find the MaxInsertCommitSize custom property in my sql server destination in SSIS packages.

is there anything specific i need to do to see that.

--

Mahadevan H

That property is not on the SQL Server Destination, it's on the OLE DB Destination.|||

Hi Jwelch,

thank you for your reply. But please refer the following URL from MSDN. It says it is the property of the SQL Destination.

http://msdn2.microsoft.com/en-us/library/ms135971.aspx#sqlserver

Regards

Mahadevan H

|||

h_mahadev wrote:

Hi Jwelch,

thank you for your reply. But please refer the following URL from MSDN. It says it is the property of the SQL Destination.

http://msdn2.microsoft.com/en-us/library/ms135971.aspx#sqlserver

Regards

Mahadevan H

The documentation is correct, it is there. I've pulled a SQL Server Destination into my dataflow, hit F4, and I can see the property in the properties pane.

I'm confused as to why you think it doesn't exist?

-Jamie

|||

Hi,

when i do the same thin i am not getting that property. I am wondering why.

Regards

Mahadevan H

|||

What service pack have you got installed. I am on SP1.

-Jamie

|||SP1 only.|||

h_mahadev wrote:

Hi Jwelch,

thank you for your reply. But please refer the following URL from MSDN. It says it is the property of the SQL Destination.

http://msdn2.microsoft.com/en-us/library/ms135971.aspx#sqlserver

Regards

Mahadevan H

Doh! You are absolutely correct. And, when I rechecked, it is showing up for me as well, just as Jamie mentioned.

If you right-clcik the task, choose Advanced Editor, go to the Component Properties tab, and look in the sction for Custom Properties, does it show up there?

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.