Newbie - test FTP file information.

[MrPeds]

Hi,

This may well be an easy one but:

I have some VB code that tests the age of a file I want to FTP from a remote server. If the file is less than 1 hour 15 minutes old then I carry on with the FTP.

If the file is > 1hr 15 then I wait for 1 minute then try again. I wait for upto 10 minutes before stopping and raising an error if the file is not the correct age.

Is there a simple way of doing the same as my VB code but in DTS ? I basically want the same thing as my VB code but want one part of the DTS package to test the age of the remote file (i have the host IP address, and a username and password).

At the moment I use a batch file to get the file details from the host e.g:

open xxx.x.x.x
username
password
cd someFolder
mdir file.csv C:\Data\file.txt
y
quit

This is possible in DTS?

Regards,

MrPeds

 

[nigelrivett]

You can do it it in dts but is probably easier in a stored procedure. See

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

and

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

(That's a put but a get is similar).

======================================
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.

 

[chamilz]

Hi,

We have a process(DTS) to FTP text files nightly and weekly. Some of these files exceed 50 MB (weekly file). Most of the weekly jobs are running during week end. If any of FTP process fails, users are notified via emails. But we have no clue about the size and the number of records of the FTPed files. Some time this process fails to generate error message when this process transferred part of the file.

Now we need a method to validate FTPed file size with the source file size to verify that we FTP whole file. Do you have any idea on how to implement an error checking method or is there a tool available to FTP files with error reporting, especially to validate the size or number of records of the files before and after FTP.

Thanks,

 

[chamilz]

Thank you...

I will give a try...
/Thanks