Import data to SQL DB Using Bulk Upload

[gelayaraja]

Upload Data from CSV File to SQL Server 2005 DB using Bulk Upload is slow process.Record are present aroung 2.5 Lakhs record in CSV Files. i have return procedure for uploading data to DB. Automatic File and Table mapping using information_Sch ema.columns.

How to improve performance.Can any help or provide solutions.

[ck9663]

How many records? How many rows? Does your table has index? Check the size of your database. Is it too small and needs to grow multiple times in a single load?

Good Luck!!!


~~ CK

[gelayaraja]

More 2.5 Lakhs Data ,15 to 20 rows .No Index is present that table.Daily upload table..Datsbase size is 1.5 TB..

[ck9663]

How fast does your upload take?


~~ CK

[gelayaraja]

It take more 1 Hrs for each tables

[ck9663]

Wait, am confused.

There are 15-20 records per file and there are about 250,000 files per day and each file takes 1 hr?

Did I have it right?


~~ CK