Hi All, I am trying to use this expression in a derive column but its erroring out with truncation error. Any thoughts on this? Thanks in advance! @[User::FolderPath] + [Column 0] + (DT_STR,1,1252)MONTH(GETDATE()) + (DT_STR,1,1252)YEAR(GETDATE())

I think it's the (dt_str,1,1252) the month/year has a length greater than 1. If you only need the first char, the you need to add a substring. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I think it's the (dt_str,1,1252) the month/year has a length greater than 1 Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com yes as Joost indicated increase the length from 1 when you are casting to string .Shailesh, Please mark the post as answered if it answers your question.

Try this: @[User::FolderPath] + [Column 0] + (DT_STR,2,1252)MONTH(GETDATE()) + (DT_STR,4,1252)YEAR(GETDATE())