Issue with Projection with SRID-4283

Question

I am trying to insert data to a table in SQL Server which has column of geometry type and it data already with SRID 4283.

Even my new records will have same SRID.

But while loading alteryx fails to load saying:Error: Output Data (25): The selected Projection does not match the table's current Projection.

Any help is appreciated.

Let me know of any more details if required.

Thanks

Ramana

MikeSp · Accepted Answer

Hi @ramatp30,

Just to verify, have you set your projection properly in the Output Data's configuration to match up with what your SQL Server expects? By default, Alteryx will try to output data in WGS84 unless otherwise specified.

You can find more about this in our documentation on Projection Support.

ramatp30 · Accepted Answer

Thanks for you reply @MikeSp.

I have tried changing projections but no luck.

So as a workaround now i have loaded my data to a new table from alteryx and then using inserted to my actual table in SQL Server.

Thanks,

Ramana