Ch. 3 SQL Task Errata
Example described in figure 3-21 updates DimProduct, but the text refers to a DATE field, i.e.:"for this initial example, we mapped the System::ContainerStartTime to the OLE DB data type of DATE. At this point, the Execute SQL Task with this simple update statement could be executed, and the ModifyDate would be updated in the database with a current datetime value."