Home Forums SQL Server 2005 SQL Server 2005 Integration Services Foreach Loop (Text Files as Flat File Source and Excel files as Excel File Destination) RE: Foreach Loop (Text Files as Flat File Source and Excel files as Excel File Destination)

  • March 28, 2013 at 8:03 am

    #1601627

    Excellent - now follow part (3) of my advice. Edit your Excel connection manager (not the Excel destination) and open up the Expressions property.

    Create an expression for the ExcelFilePath property - set this to your new variable.

    Fingers crossed ...