Thank you for your reply. So using Json source connector is not easy way of doing it ?

I will try to use phython or I can use visual studio project...

hi All,

Thank you all for your inputs.. I was able to solve the issue by changing the parameter type as date instead of smalldatetime.

HI SSC-Dedicated,

I did edit it because there were spelling mistakes in my post too..

Thanks a lot, That was really helpful .

I was able to see who changed/altered the table.