I'm building a SSIS job using a foreach loop to import several MS Access files. I have the Enumerator set up for file name only because I need the filename in the target table (adding it as a derived column called "Site").
I'm at the point where the tutorials have me using the "filepath" variable to set the connection string for each interation. Since it needs a full filepath I'm trying to use something like:
'C:\Folder1\Folder2\' + @[User::Site] + '.MDB'
I've tried single quotes, double quotes and no quotes. How can I added the missing (and static) parts of a file path?