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...
brianrandolph's avatar
brianrandolph
New Contributor III
8 years ago
Copy LinkReport

you shouldn’t need parenthesis around the name. “_field1” should work.

jhagist's avatar
jhagist
New Contributor III
8 years ago
Copy LinkReport

When I try it without the parenthesis around the name. “_field1” All I get is the parameter as a string.

Snap,

Any ideas??

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

    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