Bulk insert all your data (including duplicates) to the temp table. Use the SQL Server Merge statement ...
www.jarloo.com