Loading data into multiple tables based on table names

[praneshsapmm]

Hello ,

I have this requirement below . 

Invoice	Table
1	Sql_1
2	Sql_2
3	Sql_3
4	Sql_1
5	Sql_2
6	Sql_1

the invoices need to loaded into sql table as shown . Though this is sample data , the invoices information and number of tables in very huge where filtering the data by table and then loading is very crude . is there a way like batch macro , which can loop in and load the information .

Thanks

[DanielG]

@praneshsapmm   Have you tried to create the output path in a formula with the Table column added on, then at the bottom of the output tool use the check box and change entire path so each record will pass to the appropriately named output?

[DanielG]

It also allows you to drop the created path name so it doesnt appear in the data (check box on the right of second dropdown).  very handy.  :)