I am glad that you could resolve the issue. One other note of caution: When SSIS packages are generated dynamically using SSIS 2014, the connection manager's property ColumnNamesInFirstDataRow is...

I think we will use a predetermined value such as -1 or -99 to recognize when to set the column to null. Thanks for the suggestion.

The update stored procedure is created with parameters to receive values for all updatable values, with default value of parameters set to NULL (e.g., @Col1 = NULL, @Col2 = NULL,...

The update stored procedure is created with parameters to receive values for all updatable values, with default value of parameters set to NULL (e.g., @Col1 = NULL, @Col2 = NULL,...

Thanks, for the reply. My problem is that the table has many columns, and in each call, the middle tier calls the stored procedure with only changed values. ...