Source: Azure Blob; Target: IaaS SQL Server VM / Azure DB - Enable detailed mapping of SQL server types.
We have a SQL Server (2014) table with data types like nvarchar(5), datetime, etc. At the moment loading data into an table with these data types fails. nvarchar(5) results into truncation errors. Datetime results into conversion errors.
Thanks for the great feedback. We are working on a robust type system in the product and will keep you updated once this lands in production.