|
scabral7
Yak Posting Veteran
53 Posts |
 Posted - 02/01/2013 : 13:22:06
|
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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 02/02/2013 : 01:43:21
|
yep.
Make use of data flow task
it will have an excel source to start with and this reads data from source excel
use conditional transform next and add three outputs based on agentname (Agent="Rogers",Agent="SAN",Agent="123 Agency")
Take each of the outputs and join to excel destination and give name as agentname
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
SSIS Read Excel rows and create new output
