If anyone knows anything about microsoft Dataverse, or just likes to debug sql-targets in general, feel free to take a look at https://github.com/storebrand/target-mssql/issues/10

try

pyodbc

instead if you have a way to replicate the issue. pymssql caused so many random small issues for me I moved away from it (not saying that's' the issue here as I don't know) Once you get an example record live will be a lot easier. https://github.com/storebrand/target-mssql/blob/main/target_mssql/connector.py#L356 should probably be a bigint. Also https://github.com/storebrand/target-mssql/blob/main/target_mssql/connector.py#L358 is going to cause issues at some point, going a bit higher as a default might work better 🤷 https://github.com/storebrand/target-mssql/blob/main/target_mssql/connector.py#L360 should probably be a BIT type instead but I"m way off topic at this point

Thanks! Hmmm… hadn’t considered pyodbc, I stayed clear of it because odbc makes me think of installing drivers which I try to avoid if I can.

I agree with the preference of

pymssql+freetds

over

pyodbc+odbc blob proprietary drivers

. I might throw my hat in the ring for debugging this one.

I agree I'd rather use pymssql but pyodbc has just worked better for me 🤷