I am trying to insert rows from a datatable to database using the insert query in a for each row activity. There are few columns in the Datatable which have both null and non-null values. While running the code I am getting “Execute Non Query: Data type mismatch in criteria expression” error due to the blank rows (data type being System.DBnull).
Is there any way I can insert both null and non-null values from the datatable to database. The parameters that I have defined are as follows: