dario.quinn (3/21/2013)
Just now I have a date column with format of 2011-05-25 I would like to split this into three columns:Year Month Day
2011 05 25
Can this be done using SSIS ? or even in SQL OLE DB?
TSQL is the easiest option, but if you're feeling adventurous you can also do it in a derived column using similar functions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP