Using Bulk Upload ,we are uploading Data which present in files .but in Data file for some fields has extra space ,But Field length Eg: Char(1) ,Because Space Char(2).
How to resolve this issue.
gelayaraja
Last Activity: Oct 19 '12, 01:59 AM
Joined: May 22 '12
Location:
-
Using BULK upload, how to remove Space present in file
-
It take more 1 Hrs for each tables -
I think so u copied with special charater which is present in Command Line or Missing single character in that program.
Just compare which u code and copied code.Leave a comment:
-
More 2.5 Lakhs Data ,15 to 20 rows .No Index is present that table.Daily upload table..Datsbase size is 1.5 TB..Leave a comment:
-
Import data to SQL DB Using Bulk Upload
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.
No activity results to display
Leave a comment: