need help in ssis expression

Question

Hi Guys

I have a sql statement and i want the equivalent ssis expression for both sql statement

SQL Statement:-

SELECT right(cast(getdate()as date),2)+' '+DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY]  

SELECT right(cast(getdate()-3 as date),2)+' '+DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY]  

Result Screenshot

Any help will be appreciated

Regards
Farhan Jamil

Answer 1

never mind. solved it myself

equivalent ssis expression

RIGHT("0" + (DT_WSTR, 2) DATEPART("DD", DATEADD("day", -3, GETDATE())),2)+" "+(DT_STR,50,1252)TRIM(SUBSTRING("January Febuary March April May June July August September October November December ",((DATEPART("MONTH",GETDATE())-1)*10)+1,10))+" " +RIGHT("0" + (DT_STR,4,1252)DATEPART( "yyyy" , getdate() ), 4)