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...
transform
anubhav_nautiya's avatar
anubhav_nautiya
Contributor
6 years ago
Copy Link

Seems like snaptype_localdate in your input is going as string, but the DB is expecting a date field, can you try to convert this to date and then pass it in the input to the DB.

  • 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