if statement for filenames
I am currently pulling files from an ftp to use in an ssis package. At the moment I am using a wildcard to find the file as I know it will have a specific word in it. Unfortunately the company I am pulling these from also puts up test files with the same word in them and I am pulling test data. Is there a way to use an if like statement in order to determine if the word 'test' is in the filename and if so not download this file?