I am facing one issue that i dont know in advance if there is file on FTP or not. I scheduled a job which runs every hour which in turn calling SSIS package.
Now, when there is file on FTP, it works fine. But, when there is no file on FTP then itthrows error which i want to handle.
Is it possible to check for any files present on FTP?
View Complete Post