sql server programming: SSIS Package fails with Cannot open the datafile on large flat fil -- sql server programming

SSIS Package fails with Cannot open the datafile on large flat fil

jman
5/24/2007 7:53:01 AM

sql server programming:

We have an ssis package that imports a 2GB flat file.
Sometimes it works and sometimes we get this error:

Error: 2007-05-23 16:19:07.88
Code: 0xC020200E
Source: Data Flow Task US File In [73]
Description: Cannot open the datafile
"\\computerName\data$\sharefile\LongPath\Load_Filel\FlatFile_Import.txt".
End Error

We import alot of other files this way and don't have any issues, but none
of them are this large. I think the problem is due to the large file size.

RE: SSIS Package fails with Cannot open the datafile on large flat fil

jman
5/26/2007 7:39:00 PM

I think it's some sort of network problem, the first time we run it, and it
fails. Then the second run it works. Any suggestions would be greatly
appreciated.

[quoted text, click to view]

RE: SSIS Package fails with Cannot open the datafile on large flat fil

John Arnott
2/23/2008 1:19:54 AM

This problem could be caused by the task that reads the file (your dataflow) may be starting before the entire 2GB file has been written. There may be an entry in the directory for it, which would trigger a WMI watch task for instance, but until the entire file is written, an attempt to open it would fail.

From http://www.developmentnow.com/g/113_2007_5_0_0_974903/SSIS-Package-fails-with-Cannot-open-the-datafile-on-large-flat-fil.htm

Posted via DevelopmentNow.com Groups

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.