Hi guys trying to convert
16JAN2014 --> 16/01/2014. Any ideas??? i'm trying to avoid the horrendous expression of ? JAN : 1 ? FEB : 2 etc. etc.
SSMS will quite happily do SELECT MONTH('16JAN2014') to get me the number of month however MONTH( "16JAN2014" ) will not work in SSIS.
hmmm... tried code but keep getting error below...

Asked by jhowe
(271 rep)
Jan 16, 2014, 02:15 PM
Last activity: Jan 16, 2014, 05:42 PM
Last activity: Jan 16, 2014, 05:42 PM