BULK INSERT TASK IN SSIS
Cannot fetch a row from OLE DB provider “BULK” for linked server “(null)”
August 13, 2009
[Bulk Insert Task] Error: 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.Bulk load: An unexpected end of file was encountered in the data file.”.
Wrong setting of ColumnDelimiter= tab when actually it was ColumnDelimiter= comma.
You should choose ColumnDelimiter= comma [for bulk insert] as see below
create table Cricketerinfo(cid int,cname varchar(30),cposition varchar(30),cage int)
select * from Cricketerinfo
you can know in T-SQL to do same task as see below:
BULK INSERT dbo.Cricketerinfo
FROM 'D:\SQL\My SSIS\Cricketerinfo.txt'
WITH ( FIELDTERMINATOR =',', FIRSTROW = 2 )
Demo from web: