Thanks @Nandan Hegde .
Hello @KarthikShanth ,
Great question and I did tried to repro the issue and I was able to do that .
Took some dummy data .
--DROP TABLE DATETEST
CREATE TABLE DATETEST
(
ID INT ,
SOMEDATE DATETIME NULL
)
SELECT GETUTCDATE()
INSERT INTO DATETEST VALUES (1,'2021-03-16 21:51:35.907')
INSERT INTO DATETEST(ID) VALUES (2)
--DROP TABLE DATETEST_DESTINATION
CREATE TABLE DATETEST_DESTINATION
(
ID INT ,
SOMEDATE DATETIME NULL
).
Please uncheck "Use Type default" and that should do the trick . I am sharing the snapshot for reference below .
let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members