Hi
I have created a package for the following requirement:
Pull the order(text) files from the FTP server every 30 minutes.
Process and Load the files to the database.
Archive the order files.
I have scheduled the package to run using SQL Server Agent.
The package runs successfully when the file does exist in ftp server. However, the package fails when there is no files in the ftp server.
How to configure FTP task to prevent this error?
Any idea/suggestion/alternative/link would be great.
Thanks
Ganesh