I am trying to use Custom sql to send a parameter to write back to snowflake , I know that you can write back with Initial SQL at connection time but i
![I'm getting the error ' Cannot insert the value NULL into column 'id', table 'DatingP.dbo.relationship_type'; column does not allow nulls. INSERT fails. ' and I'm not sure how to fix it. : I'm getting the error ' Cannot insert the value NULL into column 'id', table 'DatingP.dbo.relationship_type'; column does not allow nulls. INSERT fails. ' and I'm not sure how to fix it. :](https://preview.redd.it/ppbaog7plu361.png?width=570&format=png&auto=webp&s=81615c85226c1f0a82cd591492dd27469bda0b3c)
I'm getting the error ' Cannot insert the value NULL into column 'id', table 'DatingP.dbo.relationship_type'; column does not allow nulls. INSERT fails. ' and I'm not sure how to fix it. :
![The multi-part identifier “” could not be bound. with insert statement to get non insert values into OUTPUT variable in SQL Server – SQLZealots The multi-part identifier “” could not be bound. with insert statement to get non insert values into OUTPUT variable in SQL Server – SQLZealots](https://latheeshnk.files.wordpress.com/2018/01/output_after.jpg)