Post reply

Splitting up a date column into three columns

  • June 12, 2008 at 3:07 am

    #122127

    hi,

    MY excel table is given below.

    S.No.Emp. CodeEmp. NameDate In OutActual In HRSTotal HRS.

    1153LAKSHMI V6/11/200810:0919:1608:3709:07

    I want to create a table in sql server by creating package.I want to split the date column (6/11/2008) into three seperate columns namey month,date and the year in the SQl.How i can do this using SSIS? Help me out friends?

  • June 12, 2008 at 5:04 am

    #827743

    Use a derived column component in your data flow. There are functions for parsing dates.

  • June 12, 2008 at 11:02 pm

    #828242

    hi Mic,

    As per you suggested i have used the derived column for splitting up the date (08/27/1982) into three columns day,month and the year.The package executed successfully but the columns doesnot showed up in the sql table.

    I have used three components

    Sql source,Derived columns and the sql destination. I could not figure out what went wrong in mapping...help me out miche....

    Thanks & Regards

    vijay

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply