Taking month and year

Question

I have a variable containing it an expression that corresponds to a directory of folders.

I want the year and the month before:

"c: " + SUBSTRING( (dt_str, 50, 1252)GETDATE(), 1, 4 ) + " " + RIGHT("0" + (DT_STR, 2, 1252) MONTH( DATEADD("MONTH",-1,GETDATE()),2)

Sai: c: 2017 09

, but let’s imagine that it is January and the previous month is (12) and the year is also the previous. The way it is, every year I would force myself to intervene.

There is no way around this and put a relationship between the month and the year, so that it is always automatically?

Answer 1

Get it with a case, the case in SSIS Express is like this: https://docs.microsoft.com/en-us/sql/integration-services/expressions/conditional-ssis-expression?view=sql-server-2017