Due to some reasons, all source tables are not indexed. When I use fast load option to load the data of the tables into target table, is that possible I lose some rows because of incorrect property setting on ole db destination, such as 'lock table' 'check constraints' 'keep identify'? I do have some missing records, no filter is set up. Or is Non-indexed source the cause? I find if I use 'table or view', regular row-by-row loading, I can get back the missing records that couldn't be loaded in fast load. Appreciate your advice much.

If you plan incremental feeds with out indexes on source table the process would take ages for large data migrations. you can check CDC for incremental feed in SQL 2008 here are good sample for CDC http://www.mssqltips.com/tip.asp?tip=1755&ctc http://uk.linkedin.com/in/ramjaddu

data loss do not occur because of this settings. try to set the rows per batch value and see the difference. I suggest you to use ADO.NET source and destination with BULK load option. it may help you. Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com

thanks RamJaddu for the quick reply. So far we don't have a plan to migrate 2005 to 2008 but I know the CDC is a good tool.

data loss do not occur because of this settings. try to set the rows per batch value and see the difference. I suggest you to use ADO.NET source and destination with BULK load option. it may help you. Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com thanks Ayyappan. I don't see much difference between ole and ado. Why? thanks again.