Hi Kazmerelda,

The approach I usually take for things like this is to adjust the dates rather then try to parse strings.

DATEADD("MONTH",DATEDIFF("MONTH",(DT_DATE)"1900-01-01",GETDATE()) + 1,(DT_DATE)"1900-01-01")

We get the number of months between the 01/01/1900 (use 01/01/1900 as the 0 date in SSIS is 30-12-1899 for some reason) and the current date.

Add 1 to that then add that number of full months to 01-01-1900, so it always lands on the 1st of the month.