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 6:44 am

    #1601595

    kpann (3/28/2013)

    I appreciate your response but do you think you could give me an example in your package? Do you think that ExcelFilePath will change dynamically for every iteration?

    Sorry, don't have time to do that at the moment, but yes - if you use variables and expressions in the way I described it certainly should change with every iteration of the FEL.