I have below data in a single flat file.
ID Name Salary Address
1 aaa 25000 Pune
2 bbbb 30000 Bangalore
After loading data using flat file source. I have to split the data into 3 different tables, like below tables
In a single Data Flow Task, how can i split the data (with out using multicast task) into 3 different tables, is there any way ?
Is it Possible using Script Component ? if yes, how it is ?