• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

Bulk Inserts

Currently I read in a file and then take each line from the file and run an INSERT statement. A bulk insert would be much faster however getting all the SQL servers to give the appropriate permissions would be too difficult right now.

Is there any other way to speed up the INSERTS?

Thanks
0
tricks801
Asked:
tricks801
3 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
What about DTS and BCP
0
 
sparabCommented:
You can use Select ..... into statement

It is faster too....
0
 
imran_fastCommented:
Which version of sql you are using.

for sql 2000 DTS will be much faster and you need write persmission on the table where you are inserting records
for sql 2005 SQL integration services will do the same.

They are faster than reading record one by one. offcourse the DTS (SSIS) functionality in sql 2005 is much faster than dts in 2000
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now