Splitting up a date column into three columns

• elegantkvc

  SSCommitted

  Points: 1910

  More actions

  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?

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  June 12, 2008 at 5:04 am

  #827743

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

• elegantkvc

  SSCommitted

  Points: 1910

  More actions

  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