Forum Discussion
Solved
Dataflow Gen 2 to Populate the SQL Server tables issue
I would like to check if anyone has used Dataflow Gen 2 to populate tables inside SQL Server database? I have that table drop in SQL Server, create a brand new table inside SQL Server database, whic...
The count reported by `Table.RowCount(TableToInsert)` reflects the number of rows in the dataflow’s in-memory table, not necessarily what is committed to SQL Server. If there is a failure during the write operation (due to constraints, timeouts, or connectivity issues), not all rows may be inserted,
The count reported by `Table.RowCount(TableToInsert)` reflects the number of rows in the dataflow’s in-memory table, not necessarily what is committed to SQL Server. If there is a failure during the write operation (due to constraints, timeouts, or connectivity issues), not all rows may be inserted,
I have more than double the rows of 159128 in SQL Server.