I have a task where we need to retrieve the data from multiple tables and then store them to different database with similar structure. So I have created a configuration table where all the required queries are written to pull the data and by iterating that i am able to create the delimited output files . I have used dynamic schema feature to handle the columns. Now i want to insert those files to destination database using dynamic schema. But I am facing two Issues 1. while passing the table name from the global variable it gives error that table doesn't exist . The root cause behind this is the table is enclosed with " ". 2. Not able to set the schema dynamically.
... View more