I am trying to write two columns, both of a string datatype, to a table in our managed SQL server. The destination columns are both varchar(100), the output columns in the dataflow are string, the data preview it lit up green with successful inputs, but when I publish and trigger the pipeline nothing is written to the table.

I have 10+ other data flows successfully doing the same thing but writing to a different database that’s in the same managed server. I don’t know if the different db is causing the issue, but I’m out of other ideas.