Home Forums SQL Server 2005 SQL Server 2005 Integration Services writing data from Table to Excel files in Loop based On a condition RE: writing data from Table to Excel files in Loop based On a condition

  • April 10, 2013 at 12:27 pm

    #1605366

    Thank you for the reply.

    Since I am writing to 5 Different folders, I need to create 5 differnt Excel destination connections.

    I would like to have a solution to get a foldername dynamically and match to prefix of the ID. I don't want to create multiple Excel connections. Can you please give a solution to achieve this.