• You can use two variables, one to store the current file name and to concatenate the file name. The way you do it is using an expression builder to the second variable to add the new file name every time it goes into the loop.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.