Best way to load data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Best way to load data

I am creating a .net application that will report off of data in sql server. One requirement of the app is for a user to be able to load new data into the db from excel files. The data is being loaded into a table that has a composite primary key. I’m trying to figure out the most efficient way for the db to only insert rows that aren’t already in the db. Rob Mills
DTS is most efficient and best way to go forward, refer to books online for more information. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Also refer this Madhivanan Failing to plan is Planning to fail
See if this helps:
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterst�tze PASS Deutschland e.V.