I have migrated a DTS 2000 package containing a Data transformation task to SSIS 2008. After migration I see that that in the OLEDB destination task editor for "FastLoad" data access mode below are the settigs: 1.Maximum insert commit size = 2147483647 2.Rows per Batch = 1 In the old DTS package, the two properties were "Insert batch size = 0 and Fetch Buffer size = 1". Please let me know if these two properties in the old dts package corresponds correctly to OLEDB destination task in the migrated SSIS 2008 package? Or do I have to change anything in the SSIS pkg.

Hi, I don't know the meaning of "Insert Batch Size" & "Fetch Buffer Size" in DTS but the values that you have there for "Maximum Insert Commit Size" & "Rows per batch" are fine. "Maximum Insertt Cmmit Size" is the important one here because it specifies the number of rows that SSIS will insert before issuing a commit. By setting it to an arbitrarily large number like 2147483647 (which, by the way, is the default) you are effectively saying "commit all or nothing". Regards Jamiehttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi Jamie, Thanks a lot for your reply. Also, "rows per batch = 1 " fine in SSIS 2008 package. It was automatically set to 1 when I migrated the package.