How can I eliminate false "connection string format is not valid" messages from SSIS log?
If you use the Excel connection manager for example, you should set the ExcelFilePath property as an Expression instead of the ConnectionString !