Sample Header Ad - 728x90

ssis convert ddmonyyyy dd/mm/yyyy

2 votes
1 answer
5970 views
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... enter image description here
Asked by jhowe (271 rep)
Jan 16, 2014, 02:15 PM
Last activity: Jan 16, 2014, 05:42 PM