Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlval
Starting Member
12 Posts |
 Posted - 2011-05-03 : 12:40:20
|
| I am trying to put together an expression in derived column transformation editor, but can't get it to work. I have a year and a month in the table - both values are integers. I need to create a date that will represent the last day of the given year and given month. Any help will be appreciated. |
|
|
sqlval
Starting Member
12 Posts |
Posted - 2011-05-03 : 14:50:46
|
| In case if anyone needs it: DATEADD("dd",-1,DATEADD("mm",1,(DT_DATE)(DT_DBDATE)((DT_WSTR,4)YR + "-" + (DT_WSTR,2)MTH + "-01"))) |
 |
|
|
|
|
|
SSIS Expression