A specific task of importing data from a text file or any data source where heave inserts and updates are involved is quite common scenario in any SQL Server platform. So when you need to perform such actions on regular basis you need what's the best way to import data from text files into SQL Server where a mix of inserts and updates is required? Worktable or rather we can call a staging table, a best way to take this forward. As per the configuration the bulk-load features in SQL Server only provide...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/11/08/best-option-to-choose-when-importing-data-from-a-text-file-where-heavy-inserts-and-updates-are-involved.aspx