Created Excel files dynamically in SSIS

  • Can we load the data from multiple flat files (located in different folders) into multiple excel files (NOT excel sheets) using SSIS? Is there a way to create one excel file for each flat file dynamically? Please help! Thanks in advance.

  • If all the flat files have the exact same structure: yes. Use a For Each Loop with a dataflow inside and expressions on the connection managers.

    If they don't have the same structure: no. It's not possible. You'd need to create seperate dataflows for each flat file.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply