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?
Jan 09 '12 at 11:55 AM
Jan 09 '12 at 12:34 PM
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.
Jan 09 '12 at 12:37 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Jan 09 '12 at 11:55 AM
Seen: 885 times
Last Updated: Jan 09 '12 at 12:34 PM
SQL Server 2008 remote backup
Exception File (Tranform Data Task) in DTS alternative in SSIS
DTS to SSIS migration throwing Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".
SSIS Temp table created in one Execute SQL Task in not available in next SQL Task
Any Example on how to configure CSV file to run SSIS packages via Batch File
dts from ssis 2008
Reading Data Pump Task in DTS without having source and destination environment
Tips & Tricks On SQL Server 2000 DTS Migration To SQL Server 2008 SSIS
Adding two column values in SSIS
Passing parameters to the stored proc from csv source to populate data in the destinaton
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.