Hello,
I have an XML file (consists of 300+ entities) that I wish to insert to Azure SQL, thus creating 300+ tables.
When inserting data to Azure (contrary to SQL Server) you must specify a primary key or a clustered index. I know this type of functionality is feasible by changing the attributes of the Writer at the Index column.
However, doing this for 300+ tables manually, is not sustainable.
Dynamic writer was not able to assist either. My other thought is to read as merged dataset, create a uuid and then using SQL Executor assign this attribute as a clustered index in every table? In this case, will the Writer be able to pick up this automatically?
Other suggestions are much appreciated.
Kind regards,
George