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.
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.
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.
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.