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