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.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2008-02-19 : 14:42:09
|
| Hi i am trying to bulk insert records from flat file to sql table, but i am getting the following errorError: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.Cannot bulk load because the maximum number of errors (10) was exceeded.".Task failed: Bulk Insert Task can any one guide me regarding this.-Thanks N Regards,Kanthi. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:25:56
|
| How's your bulk insert statement look like? Where is data file? |
 |
|
|
anuksundar
Starting Member
4 Posts |
Posted - 2008-02-21 : 06:19:49
|
| hito bulk insert in sql servercreate table emp1(emp_id int,emp_name varchar(20),emp_sal decimal(10,2))BULK INSERT emp1FROM 'c:\bulk.txt'WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', TABLOCK)enter the values in bulk.txt as6,sundar,300007,sesh,400008,anitha,20000this will surely workanuradhak |
|
|
|
|
|
|
|
|
Bulk Insert failed