Hi I have problems using target-mssql with below config:
loaders:
- name: target-mssql
variant: storebrand
pip_url: git+
https://github.com/MeltanoLabs/target-mssql.git
config:
host:
port:
password:
database:
schema_mapping:
dbo: dbo
default_target_schema: dbo
username:
However it ends up with a SQL syntax error which seems the incorrect compiled SQL:
2025-03-01T22
3321.089537Z [info ] pymssql.exceptions.OperationalError: (156, b"Incorrect syntax near the keyword 'WHEN'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n") cmd_type=elb consumer=True job_name=dev:tap-mssql-to-target-mssql name=target-mssql producer=False run_id=a112c421-55c2-4eaf-8d9a-663d5c38d18e stdio=stderr string_id=target-mssql
Wondering have anyone seen similar problem before?