Ale, music and enjoying life.
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.