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?