SSIS – Converting string / numeric (yyyymmdd and hhmmss) to datetime inside Derived Column Transformation Editor

SSIS – Converting string / numeric (yyyymmdd and hhmmss) to datetime inside Derived Column Transformation Editorhttp://msmvps.com/blogs/martinpoon/archive/2009/03/17/ssis-converting-string-numeric-yyyymmdd-and-hhmmss-to-datetime-inside-derived-column-transformation-editor.aspxIt takes me some time to figure out how a string / numeric value can be converted to a datetime value inside the Derived Column Transformation Editor of SSIS, and so, I would like to share my $0.20 here (in order to save others’ $0.20).   :enCommunityServer 2008.5 SP2 (Build: 40407.4157)