SQL Insert / SQL Server Execute Snaps

[KevinFord]

We have a process today that does a SQL insert into a transactional database and returns the ID value for use in later steps.  We have tried the SQL INSERT SNAP and ID is not returned.  Also tried the SQL Server Execute Snap using and INSERT statement including the OUTPUT INSERTED.ID, returned a Batch operation failed error.

Looking for examples/suggestions on how to overcome this issue.

[KevinFord · Accepted solution]

To fix the SQL EXECUTE error we changed the Query Type from auto to read and the ID was returned.  We have a feature request change into SnapLogic for the SQL INSERT snap.  Would like the option to return the ID in this snap as well.