Step-by-step process: On the SSIS package, create 3 variables are shown in screenshot #1. Scope CheckFilerepresents the package name. Variable Folder will represent the folder that you would like to check for the file. Filename represents the file name to check for. Variable FilePath will be the global variable that you will need. It will be filled in with the file path… Continue reading