How to fix my ssis date expression

SSIS does not have an in built function like SQL Server to get the Month Name .. So you will have to create a variable and write an If Else expression (Link below) to choose SEPT when its 10 ..

http://www.sqlis.com/post/Expression-Date-Functions.aspx

How do you write.. I have been staring at examples and cant get them to work.. I need this

ME_OTW_Received for Sept-11

I need the current month - 28 days ever time.. How do I write this?

Try this.. if you want currentMonth -28 days then you will need to write an Expression to get the Month of the (Currentmonth - 28 days) and use it as below

RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) .. this will give you the Month Number before the 28 days.. Use this in the below Exp by removing RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2)



"" + "ME_OTW_Received"+" for "  + RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 01 ? "January" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 02 ? "February" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 03 ? "March" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 04 ? "April" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 05 ? "May" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 06 ? "June" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 07 ? "July" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 08 ? "August" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 09 ? "September" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 10 ? "October" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 11 ? "November" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == 12 ? "December" : "InvalidMonth" + "-" + (DT_WSTR,4)YEAR(GETDATE())

Getting the attached error

Add double Quotes .. "01" instead of 01, "02" instead of 02... etc

I did that and no error but all it displays is October.. It does not display
ME_OTW_Received for Sept-11

Please read my above post ... I suggested you to use RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) instead of current Expression to get the month before last 28 days .... RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2)


you will just have to replace -28 instead of 0 in the DateAdd function

I am, I know how to get September to show but that is ALL that is displaying..

I'm getting
September
 instead of
ME_OTW_Received for September-11

Did you by mistake delete "" + "ME_OTW_Received"+" for "  from your expression ... if not please post your expression and I will take a look at it

"" + "ME_OTW_Received"+" for "  + RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "01" ? "January" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "02" ? "February" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "03" ? "March" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "04" ? "April" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "05" ? "May" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "06" ? "June" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "07" ? "July" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == "08" ? "August" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "09" ? "September" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "10" ? "October" : RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "11" ? "November" :
  RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "12" ? "December" : "InvalidMonth" + "-" + (DT_WSTR,4)YEAR(GETDATE())

It just returns September..

Not sure why the "ME_OTW_Received"+" for "  + and the year will not show with it..

Do you need SEPT  or SEPTEMPER ???

check the attched..

"ME_OTW_Received  for "  + (RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "01" ? "January" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "02" ? "February" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "03" ? "March" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "04" ? "April" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "05" ? "May" :
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "06" ? "June" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "07" ? "July" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",0,GETDATE())),2) == "08" ? "August" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "09" ? "September" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "10" ? "October" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "11" ? "November" : 
RIGHT("0" + (DT_WSTR,2)MONTH(DATEADD("d",-28,GETDATE())),2) == "12" ? "December" : "" )   + "-" + (DT_WSTR,4)YEAR(GETDATE())

Select allOpen in new window

Thanks!! Stayed with expression builder but will try other way next time.. Sorry took so long to reward points..