Keep control of file transfer
Hi,
I am using WinSCP in MS SQL Server DTS package to download files from remote to local server on daily basis.
I am doing it this way in the script file:
[...]
# Download file(s) to the local directory d:\
get *.txt c:\BaseCDR\
# Delete downloaded file(s)
rm *.txt
[...]
Is there a way to control that the files have been properly downloaded before removing them from remote server?
Consider following:
1. I cannot use remote recycle bin.
2. It has no sense to count the downloaded files on local side, since the amount of files may vary.
3. Is there any way to retrieve number of files on remote server (compare local with remote)?
Thanx in advance for your reply.
I am using WinSCP in MS SQL Server DTS package to download files from remote to local server on daily basis.
I am doing it this way in the script file:
[...]
# Download file(s) to the local directory d:\
get *.txt c:\BaseCDR\
# Delete downloaded file(s)
rm *.txt
[...]
Is there a way to control that the files have been properly downloaded before removing them from remote server?
Consider following:
1. I cannot use remote recycle bin.
2. It has no sense to count the downloaded files on local side, since the amount of files may vary.
3. Is there any way to retrieve number of files on remote server (compare local with remote)?
Thanx in advance for your reply.