SQL Azure Import Error - Operand type clash: image is incompatible with geography

1

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?


Update

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.

sql-server-2012
azure-sql-database
asked on Stack Overflow Apr 22, 2016 by Santosh • edited Jul 14, 2017 by Santosh

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0