Importing Text File from Slow Network

[smedvid]

Just a shot in the dark... Anyone ever have any issues importing a text (350 MB) file from a network drive? Basically, it appears to be a timeout issue where SQL Server DTS can not get a full handle on the file.

My solution seems to work for the short-term. I created an FTP to send the file to the local drive of the SQL Server machine.

So.. Is there a timeout or re-tery feature I could configure for a DTS when attemptingto read a text file into a SQL Server table?

tia,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[nigelrivett]

Your solution to copy the file before the import is probably better than anything else you will find.
It means there is no interaction with the dubious network while the import is actually going on.

If you make the copy a separate process from the import then it will be even better as these can run during different windows i.e. you don't need to have access to the database for the copy and the local import should be quick.

Have a look at

http://www.nigelrivett.net/ImportTextFiles.html

And the ftp stuff on the same site for the copy.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.