https://community.esri.com/t5/modelbuilder-questions/append-tool-resulting-in-null-values/m-p/1629726#M4090 <P>I've got a table on an SQL server, and another one on another server (SQL, in an Azure environment), and I'm looking at using ModelBuilder to move rows between them.</P><P>Sometimes this works perfectly - about 4500 rows, no spatial data. However, most of the time it copies the amount of rows over, but little or no data - it is mostly null. The correct amount of rows are created, but the data is null.</P><P>I've tried a few approaches, including copying all the rows from the original table locally (which get populated fine) and then populating the Azure table from there, but they still end up as nulls.</P><P>Any idea what could be causing it? As I say, it's not a huge amount of data, and copies okay sometimes just using a standard Append tool. The data is static, there is no difference in the data on different runs.</P> Thu, 03 Jul 2025 06:54:08 GMT MichaelBell 2025-07-03T06:54:08Z https://community.esri.com/t5/modelbuilder-questions/append-tool-resulting-in-null-values/m-p/1629726#M4090 <P>I've got a table on an SQL server, and another one on another server (SQL, in an Azure environment), and I'm looking at using ModelBuilder to move rows between them.</P><P>Sometimes this works perfectly - about 4500 rows, no spatial data. However, most of the time it copies the amount of rows over, but little or no data - it is mostly null. The correct amount of rows are created, but the data is null.</P><P>I've tried a few approaches, including copying all the rows from the original table locally (which get populated fine) and then populating the Azure table from there, but they still end up as nulls.</P><P>Any idea what could be causing it? As I say, it's not a huge amount of data, and copies okay sometimes just using a standard Append tool. The data is static, there is no difference in the data on different runs.</P> Thu, 03 Jul 2025 06:54:08 GMT https://community.esri.com/t5/modelbuilder-questions/append-tool-resulting-in-null-values/m-p/1629726#M4090 MichaelBell 2025-07-03T06:54:08Z https://community.esri.com/t5/modelbuilder-questions/append-tool-resulting-in-null-values/m-p/1694327#M4148 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/20743">@MichaelBell</a>,&nbsp;<BR />I am sorry you are experiencing this issue. I will try this tmro and check if this is a bug. Please would you be able to share the ArcGIS pro version you are on? Thank you!</P> Fri, 03 Apr 2026 07:22:03 GMT https://community.esri.com/t5/modelbuilder-questions/append-tool-resulting-in-null-values/m-p/1694327#M4148 ShitijMehta 2026-04-03T07:22:03Z