Check File size before importing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deheinz1 - 09 May 2005 21:57 GMT

I have a DTS procedure that runs 4 times a day. It has worked well until
now. It is reading infromation from a text file. Today the text file was
empty and DTS failed giving me this error; "The volume for a file has been
externally altered so that the opened file is no longer valid.". I believe
this is happening because the file size is 0 K bytes (This file is
constantly overwriitten). Is there a way before importing a text file to
check and verify that the file is not empty?

Reply to this Message

Paul Smith - 10 May 2005 06:42 GMT

Use FSO (File System Object) to check the size first in an ActiveX script,
you can find an exampl on sqldts.com

>I have a DTS procedure that runs 4 times a day. It has worked well until
> now. It is reading infromation from a text file. Today the text file was
[quoted text clipped - 4 lines]
> constantly overwriitten). Is there a way before importing a text file to
> check and verify that the file is not empty?

Reply to this Message

JT - 13 May 2005 22:02 GMT

Even confirming that the file size is > 0 may not indicate reliably that the
source data transfer has completed. I have a similar situation where files
are being FTP'd from the mainframe and can take 1/2 or more to complete
(assuming they do complete). My solution was to ask the data processing
staff to download the file with an extention of .TMP and then rename it to
.DAT after the download is complete.

> I have a DTS procedure that runs 4 times a day. It has worked well until
> now. It is reading infromation from a text file. Today the text file was
[quoted text clipped - 3 lines]
> constantly overwriitten). Is there a way before importing a text file to
> check and verify that the file is not empty?

Reply to this Message