C# SSIS Script Component Format Input Date Row to "MMddyyyy"

Question

I am currently working on a Transformation component script. I want to format the input date columns to "MMddYYYY".

public override void Input0_ProcessInputRow(Input0Buffer Row)
{
    /*
     * Add your code here
     */

    Row.SampleDate = Convert.ToDateTime(Row.SampleDate.ToString("MM/dd/yyyy"));
    Row.TestDate = Convert.ToDateTime(Row.TestDate.ToString("MM/dd/yyyy"));
    Row.ComponentsTestDate = Convert.ToDateTime(Row.ComponentsTestDate.ToString("MM/dd/yyyy"));
}

I am still getting a timestamp value once the scripts executes:

The screenshot looks like the data viewer. If the pipeline's column is set to data time (i.e., DB_TIMESTAMP) then the date time will should no matter what. You should be able to output that value to a DATE column on SQL Server, which will have the time removed if it is all zeros. — J Weezy
– J Weezy, Commented Jul 19, 2018 at 14:19

Tab Alleman · Accepted Answer · 2018-07-19 13:49:27Z

1

Strings have formats. DateTimes do not.

If you want to see your output in a specific format, you need your output column to be a string datatype.

answered Jul 19, 2018 at 13:49

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# SSIS Script Component Format Input Date Row to "MMddyyyy"

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related