which task is best for loading 1 million rows

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

which task is best for loading 1 million rows

Author

Topic

BhaskarDasari
Starting Member

19 Posts

Posted - 2008-03-24 : 02:52:06

Hi,

i have to load 1million rows from database( or flatfile) to the database(or flat file).
which task is used as the best solution for this?

Appreciate any assistance in this regard.

Thanks,
Das

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-24 : 09:20:34

Bulk-insert.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-03-24 : 10:46:53

http://weblogs.sqlteam.com/mladenp/archive/2006/07/22/10742.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-24 : 11:01:36

Bulk-insert with TABLOCK works fasters but locks Table.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-24 : 22:18:04

Use bcp to dump table to text file.

stephe40
Posting Yak Master

218 Posts

Posted - 2008-03-25 : 15:20:38

I would also recommend straight bcp.exe over SSIS any day.

- Eric