Hi, we have 5 million records to migrate from tera data to SQL server 2005, we need an package plan on how do we load the data to SQL. We dont have any date column,identity column in the source table and all we have is unique names thats customer names which are again repeative but can get distinct customer who would be around 5000. We need the package to perform fast. Regards, NavinNavin.D http://navind.spaces.live.com/

OLEDB Provider has a feature called fast load, take a look into the matterBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

There are loads of good tips in the white paper:"We Loaded 1TB in 30 Minutes with SSIS, and So Can You" http://msdn.microsoft.com/en-us/library/dd537533.aspx Richard Douglas Blog: Http://SQL.RichardDouglas.co.uk Twitter: @SQLRich