convert yymmdd to ccyymmdd using ssis
Hi All, My source date is in yymmdd format.I need it in ccyymmdd format using ssis derived column Please send me the expression ASAP. Thanks RHsql
September 13th, 2012 1:11pm

You need to determine where the borders are... when should there be 20 or 19 ? Something like: (DT_I4)(SUBSTRING([yourdatestring],1,2)) < 20 ? "20" + [yourdatestring] : "19" + [yourdatestring] Is the source string or integer and should the end result be string or integer?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2012 1:31pm

You need to determine where the borders are... when should there be 20 or 19 ? Something like: (DT_I4)(SUBSTRING([yourdatestring],1,2)) < 20 ? "20" + [yourdatestring] : "19" + [yourdatestring] Is the source string or integer and should the end result be string or integer?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
September 13th, 2012 1:38pm

(DT_WSTR, 2) ((DT_I4)(SUBSTRING([<DateColumn>],1,2)) + 1) + <DateColumn>http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2012 2:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics