This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
...lso tried the SQLServer 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 i...
I need to mimic Informatica’s simple connected lookup process. I want to look for a record on a target table and if it exists, update it, otherwise insert it. I have tried to use the Lookup Snap, b...
Newbie with Snap Logic.
I’m attempting to build an integration that will run once a day.
The input is coming from a SQLServer database.
There will be days when there will be no data to p...
The process established by the company I work for is that we have the document coming into a MAPPER, that links the incoming fields to the SQLSERVER UPDATE Snap. This tells the UPDATE snap which f...
Hello community,
I’m trying to setup an SQLServer Account in Snaplogic to access a database on an SQLServer.
I am able to get access to the server using SSMS, but not in Snaplogic.
(l...
I need the list of possible return codes for the insert, update of this Snap Pack.
“If an output view is available, then the original document that was used to create the statement is written to th...
Hello, To perform truncate/load data strategy for around 20 million records from SQLServer Source to SQLServer Target, I am trying to use SQLServer Bulk Load Snap. I understand t...
A statement like this works fine in SQLServer. How can I get something like this to work in the SQLServer - Execute Snap? There has to be a syntax issue that I have. Any help is appreciated.
D...