My database contains a table with Geography column having spatial data.
Importing its .bacpac (Data-tier App) on SQL Azure Standard fails without giving any proper error details.
Tried a direct Data Export using wizard and received an error:
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Operand type clash: image is incompatible with geography". (SQL Server Import and Export Wizard)
Any idea why Geography is a problem here?
I recently upgraded SSMS to 2016 and this error has gone. It must have been due to older version of SSMS that didn't support import export of spatial data.
User contributions licensed under CC BY-SA 3.0