Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    62

    Unanswered: SSIS Read Excel rows and create new output

    Hi,

    I have an excel file with following data:

    Agent State Exposure Insured Name
    Rogers Inc MA 100,000 John Smith
    SAN Group RI 200,000 Jim Morrison
    SAN Group RI 100,000 Jimi Hendrix
    123 Agency MA 300,000 Mickey Mouse
    Rogers Inc MA 50,000 Mike Greenwell

    I want to be able to read the file and create new excel files for each Agent listed.

    So for Example, the above file would create 3 separate files since there are 3 different Agents listed. Each Agent file would contain the same information from the original file. The name of the file would be somethign like AgentName.xls

    So the SAN group file would have this:

    Agent State Exposure Insured Name
    Rogers Inc MA 100,000 John Smith
    SAN Group RI 200,000 Jim Morrison
    SAN Group RI 100,000 Jimi Hendrix

    Is there a way to accomplish this in SSIS?

    thanks
    Scott

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by scabral7 View Post
    Hi,

    Is there a way to accomplish this in SSIS?

    thanks
    Scott
    Yes it is possible.

  3. #3
    Join Date
    Sep 2009
    Posts
    62
    thanks, any particular method or task that you have used before?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •