Issue: Error while refresh azure Target.
[SQL Server]Cannot convert to text/ntext or collate to 'Latin1_General_100_CS_AS_SC_UTF8' because these legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not have the _SC or _UTF8
Available Workaround: The job table needs to be created manually with varchar(max) datatype instead of text depending on the collation set up on Azure SQL database
Proposed Improvement: Generate DDL automatically based on the collation set up on Azure SQL