Table contains unsupported columns - lab 15

[VireshDoshi]

Module: 00

Lab/Demo: 15

Task: 00

Step: Create a link connection

Description of issue The link service between SQL database and Synapse shows errors like these:

SalesLT.Customer Table contains unsupported columns(NameStyle(bit), FirstName(nvarchar), MiddleName(nvarchar), LastName(nvarchar), Phone(nvarchar)). Those columns will not be replicated to Azure Synapse Analytics.

SalesLT.Product Table contains unsupported columns(Name(nvarchar)). Those columns will not be replicated to Azure Synapse Analytics.

Table contains unsupported columns(OnlineOrderFlag(bit), PurchaseOrderNumber(nvarchar), AccountNumber(nvarchar)). Those columns will not be replicated to Azure Synapse Analytics

There are also these errors Use heap table when your data contains varchar(max), nvarchar(max), and varbinary(max)

Repro steps:

1. follow the steps on the lab to Create a link connection
2. when you get to the link service replication under Integrate , you will see errors as noted above

[TheJamesHerring]

Can you provide screenshots? Nothing has changed on this lab in some time.