title: SSIS Dynamic File Name Variable vs Parameter
body: <p>I am New to SSIS. I have to fetch file name dynamically from a table. I have used parameters in my ssis package for storing the filenames in package. In the execute sql task i am planning to fetch the value from database and store it in parameters. What will be the best way to store filenames in package. Parameters or variables.</p>