I have an SSIS package that starts with an FTP task that downloads all files in a remote directory to a local folder using a wildcard... The remote directory will sometimes have files in it and sometimes not.
The package runs fine when files are in the remote directory, however if the package runs when there are no files in the remote directory, the step fails stating the remote file was not found.
If there are no files in the remote directory, I'd like the task to just continue and not error out, as that just means there are no files to process.
Can someone point me in the right direction, my only though is to do a script task first that connects to the FTP site and gets a file count or something.
Any advice would be appreciated!
The package runs fine when files are in the remote directory, however if the package runs when there are no files in the remote directory, the step fails stating the remote file was not found.
If there are no files in the remote directory, I'd like the task to just continue and not error out, as that just means there are no files to process.
Can someone point me in the right direction, my only though is to do a script task first that connects to the FTP site and gets a file count or something.
Any advice would be appreciated!