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
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Also refer this
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail

See if this helps:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¯Â¿Â½tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>