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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.