Hello everybody
I have DTS package that bulk inserts text file into the SQL server 7 table. The DTS package is called by the job and job is scheduled to run every morning (it worked fine for almost 2 years)
Yesterday out of nowhere the job failed. I got the error message
Error = -2147217900 (80040E14) Error string: Could not bulk insert because file '(null)' could not be read. Operating system error code (null). Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 4862 (12FE) Error string: Could not bulk insert because file '(null)' could not be read. Operating system error code (null). Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSBulkInsertTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed
I reran the job manually yesterday and it was completed successfully. Today exactly same error came up again and I had to run again the job manually (it was completed successfully again
The file (that I am trying to import) is located on the different server on the network (it still has 206 MB free hard drive space). Also if I try to run bcp.exe -> it imports file without any problem
The sql database(where I am trying to import the file) is located on the 2 harddrives. And total free space is about 10GB / the database log hard drive has about 1GB free space.
Any suggestions regarding how to solve this problem would be greatly appreciate
Thank you in advanc
Diana

How is the file location specified?

Is it only as a job that it fails ?

http://support.microsoft.com/?kbid=269074



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Diana M" <anonymous (AT) discussions (DOT) microsoft.com> wrote

every morning (it worked fine for almost 2 years).
(null). Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 Error Detail Records:
Error: -2147217900 (80040E14); Provider Error: 4862 (12FE) Error
string: Could not bulk insert because file '(null)' could not be read.
Operating system error code (null). Error source: Microsoft OLE DB
Provider for SQL Server Help file: Help context: 0 DTSRun
OnFinish: DTSStep_DTSBulkInsertTask_1 DTSRun: Package execution
complete. Process Exit Code 1. The step failed.
manually (it was completed successfully again)
try to run bcp.exe -> it imports file without any problems
drive has about 1GB free space.

The file path is specified as:
\\comp\fold\FileName.txt
Also I do not think that it is related to security issues. Because after the job failed I did run again a job (not DTS package directly)

But was that other job looking for that file?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Diana M" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Yes, the job was looking for the same file at all times