December 19, 2007 at 8:34 am
I'm trying to import a large (140 GB) text file from Server A into a table in a database on Server B using SSIS, and it keeps failing with "An unexpected disk I/O error occurred when reading the file". I can't find anything in any of the system logs on the servers in question. Has anyone else run into this, or does anyone know what might be happening?
Thanks-
December 19, 2007 at 9:44 am
This is typically a disk error meaning the file can't be read. Can you copy the file over? It would eliminate network issues.
December 19, 2007 at 9:49 am
Unfortunately, I cannot copy it over (space constraints)...I think I'll try importing it into a table on the source server and dealing with it in smaller chunks....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply