Azure Data Factory fails to preview data or import schem from SQL Azure Table

0
votes

I get an error when trying to create a Dataset in Azure Data Factory V2 against a table in a SQL Azure database.

The table does have a Geography field, otherwise it's a standard table!! Any ideas?

Error reported is:

'Type=,Message=Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.,Source=,'. Activity ID:52dda22e-6328-40cb-b30a-7255117ac37d

2
azureazure-sql-databaseazure-data-factoryazure-data-factory-2

2 Answers

1
votes

Geography is currently not supported.

    1. You could write a query to exclude this column if you don't need data of this column.
    1. If you want to copy it to another azure sql or sql server as-is, meaning you don't need specify column mapping (column name between source and sink are well matched), you could skip the preview and schema.
0
votes

I opened a support call with Microsoft and after verifying the issue, they were surprised that Geography fields caused this failure. I have been told that they will be working on a fix and await an update of when this will be applied.