question

pvsrinivasrao avatar image
pvsrinivasrao asked

SSIS Analagous setting for DTS Insert Batch Size in Data Pump Task

Hi , What is the SSIS Analagous setting for DTS Insert Batch Size in Data Pump Task, I am assuming its Maximum Insert Size on a OLEDB Destination?
sql-server-2008ssisdts
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
SirSQL avatar image
SirSQL answered
That's correct. Note that this only applies to fast load operations however. Please see http://msdn.microsoft.com/en-us/library/ms188439(v=SQL.105).aspx for more detailed information.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.