DateTime data insert to sql server

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Is it because we are using object or because of Null?

If it is because we changed to object now we can change to Nullable datatetime I believe as we are using a IF activity

If it is because of Null try to Give Nothing

Insert Null into a date database field via database execute query

Hi Ritesh, please find below example:- “DECLARE @test_value int EXEC @test_value = [dbo].[Tasktest] @testId, NULL, NULL, NULL, NULL, NULL, @ID OUTPUT” you need to directly pass “NULL” at the column position. no need to specify the column name. let me know if it clarifies.

can you show the error

cheers