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:06 pm

    #1605360

    Data Flow Task containing:

    1. OLE DB Source that selects the data you need to export as a single resultset, i.e. a SELECT statement

    2. Conditional Split that evaluates the ID column and creates 5 output streams based on the 5 folder prefixes you mentioned

    3. Have an Excel Destination connected to each of the output streams that writes the data into the Excel sheets you mentioned.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato