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 th...
  • KevinFord's avatar
    2 years ago

    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.