Hello, anyone has experience with Sql Server as a ...
# plugins-general
m
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
Of course my expected result is that no columns should be created, since the table already exists with all the appropriate fields.
v
If I need really specefic behavior from a target I fork and do that myself. In this case for you I'd try to target a different schema, see if you can get the table running with meltano, then once that works if you're 100% keen on keeping that table with the exact column casing then I'd make a SQL script to move data between the "raw" meltano table and the "prod" table you currently want meltano to target
👍 1
a
@Marco Lardera which tap are you using to generate the data?