HI, I am working on BUlk Insert from a file to a table in SQL server 2005. Id int, EmpName Varchar(20), EmpAge Varchar(3), EmpNumber Varchar(6), EmpDOB Varchar(10) The SSIS always fails and reports as [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.". Pls help

could you set timeout for sql server destination connection as 0 and try again?http://www.rad.pasfu.com

HI, could you pls tell me where to set the sql server destination connection as 0? Sorry for bugging you am new to ssis. thanks,

HI, could you pls tell me where to set the sql server destination connection as 0? Sorry for bugging you am new to ssis. thanks, in the connection managers section, find the connection manager you used in bulk insert, then double click on it. go to tab ALL, and check the connect time out to be 0http://www.rad.pasfu.com

Hi, ya its 0. Its already been set.

still the problem exists

The problem still persist. Pls guide me to avoid this error.

maybe there is a problem in the file, did you checked row delimiters and column delimiters? are they correctly placed?http://www.rad.pasfu.com

Yes everything is correctly placed. and i checked many a times.

Yes everything is correctly placed. and i checked many a times. I think end of file has a problem, look at this message in your error message: An unexpected end of file was encountered in the data filehttp://www.rad.pasfu.com