Output to Microsoft SQL Server - No error but no data

[vromer]

Hello, I managed to create an output connection to Microsoft SQL Server and mapped it to desired fields. No error during RUN but upon checking with MS SQL DB no data was being e

[vromer · Accepted solution]

I got it working, thank you so much!

[mceleavey]

Hi @vromer ,

Can you post your config etc? This could be due to a number of reasons.

One might be due to the settings in the SQL instance that restricts write capability to system tables. You can then write out to a dummy table and use a POST Create statement to copy the table over to the original.

M.

[mpot]

Hi, could you please elaborate on a dummy table? I have the same issue.