Hi All,
I am creating one SSIS package where my source is oracle.
I have transferred the data from Oracle to flat file as per client requirement.
I have to create single package for 2 country 1 is US and another is CANADA
Columns are below
ZONE_ID,
ZONE_NAME
Zone Id having data like 10001,10002,10003,20001,2002,2003
Where zone_id start with 1000 is US Zone and Zone_Id start with 2000 is Canada Zone.
For US:
1.Load geography data from DB tables into flat files
2.Load geography data from flat files to Spectrum DB tables
For Canada:
1.Load geography data from DB tables into flat files
2.Load geography data from flat files to Spectrum DB tables
Now I want to look from flat file if Zone_id start with 1000 then it must go to US_DFT and if Zone_id start with 2000 then it must go to CANADA_DFT
Kindly see the attached Screen shot for better understanding
kindly suggest me the way to come out with above concern.
Regards,
Vipin Jha