Dynamic Schema name in output tool

Question

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!!!

OutputDynamic.PNG

sjain71 · Answer

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.

sjain71 · Answer

Hi,

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

AngelosPachis · Answer

Hi @sjain71 ,

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