Forum Discussion

gowdhaman008's avatar
gowdhaman008
New Contributor II
6 years ago

SQL Server Merge Snap - Issues with Date as Null

Hi, I have developed the pipeline which reads the data from the incoming stream and send to SQL Merge. My pipeline looks like below. My Input JSON is as follows: [ { “member_id”: 13000...
siwadon's avatar
siwadon
Employee
6 years ago
Copy LinkReport

Hi @bhavani,

What version of binary snap pack are you using? Have you tried binary8741 or newer?

bhavani's avatar
bhavani
New Contributor
6 years ago
Copy LinkReport

Hi,

we are using below version
com-snaplogic-snaps-binary-zip_1-binary8710

  • gowdhaman008's avatar
    gowdhaman008
    New Contributor II
    6 years ago
    Copy Link

    Hi,

    I have tried to cast as date type. But it still could not go with SQL merge, but note that it is working with SQL Inserts.

    Thanks,
    Gowdhaman