Load performance in SQL SERver

[lak4u]

I a m trying to upset 100,000 records to sql server 2005 table,but its taking 3 hours time,actually I need to load 13000000. anybody can help please

[srinivas.g]

first load the data in to dataset and then dataset to sqlserver.

job design like

source ---> dataset

dataset ---> target (sqlserver 2005)


definitly it will give more performance.