SSIS – Manually assigning Null values

Spent a few minutes trying to assign null to a derived variable as part of a script task transform. In my mind Row.CreatedDate = null would do it right?

After, making the changes and running the data through again I could see that this had no affect and all dates I thought I’d assigned null to had the DateTime.Min values.  Not what I wanted.

After doing a bit of digging online I chanced upon the following post 

As you can see all columns have their own Row.ColumnName_IsNull – Setting the relevant columns to True worked fine.

Leave a Reply

%d bloggers like this: