3/3/2008 15:21:33

2008-03-03 15:21:33.000

Data conversion failed. The data conversion for column "TIME_STAMP"
 returned status value 2 and status text "The value could not be
 converted because of a potential loss of data.

(LEN(TRIM(TIME_STAMP)) < 23) || (TRIM(TIME_STAMP) == "")
|| (ISNULL(TIME_STAMP)) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)TIME_STAMP

(DT_WSTR, 23)
(
    (LEN(TRIM(TIME_STAMP )) < 17) || (TRIM(TIME_STAMP ) == "")
    || (ISNULL(TIME_STAMP )) ? NULL(DT_DBTIMESTAMP2, 3) : (DT_DBTIMESTAMP2, 3)
    (DT_DATE)TIME_STAMP
)

/// <summary>
/// This method is called once for every row that passes through the component from Input0.
///
/// Example of reading a value from a column in the the row:
///  string zipCode = Row.ZipCode
///
/// Example of writing a value to a column in the row:
///  Row.ZipCode = zipCode
/// </summary>
/// <param name="Row">The row that is currently passing through the component</param>
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
    if (!Row.DerivedColumn1_IsNull)
    {
        DateTime dt;

        if (DateTime.TryParse(Row.DerivedColumn1, out dt))
        {
            Row.DerivedColumn1 = dt.ToString("yyyy-MM-dd HH:mm:ss.fff");
        }
        else
        {
            Row.DerivedColumn1_IsNull = true;
        }
    }
}