I need to import multiple files from an FTP site into a database table. The problem is the files all start and end with something different, but have a common word in the middle of the file name. Is it possible in the FTP Source to add wildcard characters to the file name? Using the something an * like below did not work. Wondering if there is another way to pickup all the files I need without doing each one individually.
Please sign in to leave a comment.