Forum Discussion
tan_thiamhuat
Post Patron
1 year agoDataflow 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...
- 1 year ago
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,
nilendraFabric
Super User
1 year ago
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,
tan_thiamhuat
Post Patron
1 year agoI have more than double the rows of 159128 in SQL Server.