Forum Discussion

KevinFord's avatar
KevinFord
New Contributor
2 years ago
Solved

SQL Insert / SQL Server Execute Snaps

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.

 

 

  • 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.

1 Reply

  • KevinFord's avatar
    KevinFord
    New Contributor

    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.