Home Forums Data Warehousing Integration Services ExcelFilePath disappears after setting the ConnectionString dynamic (Expressions) RE: ExcelFilePath disappears after setting the ConnectionString dynamic (Expressions)

  • What do you mean with dissapears?

    What is the expression?

    Regarding the need for an Excel file to be present: unlike a flat file, you need to look at an Excel workbook as a database. The workbook is the database, the sheets are the tables. When you write data to a database, you'd expect the database and the tables to be there, don't you?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP