Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
To use bulk load you have to add fields definition into the bulk file or into an other file.
Best regards
Sabrina