Insert several records in an external database

Hi, A module of my application manages metadata for Data Pipelines. When a Data Engineer decides to use a certain table for his Analytical Model, he can choose the table from a list of tables. The table is added to his project. A microflow adds the specific table to the Data Sources of the project. What I tried to do is to have the same microflow to extract the schema of the table from the database data catalog and insert the fields and their definitions to a secondary table that manages the history of changes of the schema.    The query that brings the Table schema from the catalog works fine, see details of some fields bellow:   The problem is that the last Statement Execution does not insert all the rows (as number of columns) in the MSSQL table.   Please assist.   Regards, Costin Marzea
0 answers