Hello, anyone has experience with Sql Server as a target? I'm using the "target-mssql" plugin and i have a very strange issue with that.
Both the stream and the target DB have uppercase field names but, for some reason, it seems like the connector is tryng to do some ALTER TABLE ADD COLUMN statement using the lower case field names. This leades to the following error:
"Column names in each table must be unique. Column name '<lowercase_name>' in table 'dbo.<db_name>' is specified more than once.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n"
Any idea on how to solve this?
Thanks in advance