I have done like in this example:
How to loop through files in a specified folder, load one by one, and move to archive folder using SSIS
This is the connectionstring för the Excel connection manager:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test\lifecareinneliggandeIN\filA.xlsx;Extended Properties="Excel 12.0 XML;HDR=YES";
And this code I have vritten in Expressions under ConnectionString:
Everything works fine, when I write the connection to a specific file. But as soon as I change the connection to the variable ;
, then I get the error message that I need to specify filename.
I have tested to "Delay validation", booth True and False, but it doesn't work.