I have two similar SSIS packages and the other one works fine but the other does not.
I have two template excel files in a dir and they are set as the source excels in the connection manager in each package respectively. Why do I have those templates is that at least for me, unlike with Flat File connections, the Excel-connections does not obey the 'DelayValidation = True' setting, instead there has to be the file present with the same name.
This is not the cause of my trouble though.
In the other package the ExcelFilePath disappears after setting the ConnectionString dynamic (Expressions). The other one works fine. I have tried to delete and do the connection again but no luck. I just don't get it. Could some one open my eyes please!
Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE