|
kkiranvr
Yak Posting Veteran
USA
54 Posts |
 Posted - 02/19/2008 : 14:42:09
|
Hi i am trying to bulk insert records from flat file to sql table, but i am getting the following error
Error: 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. |
|
|
anuksundar
Starting Member
India
4 Posts |
Posted - 02/21/2008 : 06:19:49
|
hi
to bulk insert in sql server
create table emp1(
emp_id int,
emp_name varchar(20),
emp_sal decimal(10,2))
BULK INSERT emp1
FROM 'c:\bulk.txt'
WITH
(
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
TABLOCK)
enter the values in bulk.txt as
6,sundar,30000
7,sesh,40000
8,anitha,20000
this will surely work
anuradhak |
 |
|
Bulk Insert failed
