Tutorial by Examples

Using Derived column we can prepare the input. We will provide yyyy-MM-dd to the final conversion: Year: (DT_STR,4,1252)(DataDate / 10000) Month: (DT_STR,2,1252)(DataDate / 100 % 100) Day: (DT_STR,2,1252)(DataDate % 100) All together: (DT_DBDATE)((DT_STR,4,1252)(DataDate / 10000) + "-&q...

Using c# or vb.net code the conversion is even more simple. An output column is needed because we type can not be changed on the fly, alternative is adding an input column on forehand make it ReadWrite. Next code will fill the new column. public override void Input0_ProcessInputRow(Input0Buffer ...