KevinFord
2 years agoNew Contributor
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...
- 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.