Dynamic Schema name in output tool

[sjain71]

Hi All,

I am trying to create a macro with dynamic schema name in the output table. But I am not able to achieve that. attached is the screenshot of the macro. I am confused how to configure the input tool.

Help appreciated!!!

[AngelosPachis]

Hi @sjain71 ,

What are you looking to change exactly in your output tool? Is your goal to change the name of each tab?

[sjain71]

Hi,

I want to change the connection string in the output dynamically.

[sjain71]

I have 10 similar tables in different databases in SQL server. For eg, for the table orders I have CustomerA.Orders , Customer B.orders. Now I have to transform the data and load the data in 1 database (eg. Customer database ) which has 3 schemas (Customer A, Customer B, Customer C ) and three Tables CustomerA.orders, CustomerB.orders, and CustomerC.order. 

Now I am able to read the data from all three customers using a macro but I am not able to insert data in three tables based on customers. The problem is I can change the connection string manually but the input sample will be different for different tables (orders, products, department). How can I build a reusable macro where input varies on the tables.