SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,675 questions
Type Cast Error
Ali Ahad
131
Reputation points
I am trying to write a derived column expression to check for year. We get a data file for employees for previous month in the current month and I am trying to tackle the year so when I get the file in January the year should be 2024 since I will get the data for December, but I am getting conversion error:
my expression code
(DT_WSTR, 4) MONTH( GETDATE() ) == 1 ?
DATEADD("YEAR",-1,GETDATE()) :
DATEADD("YEAR",0 ,GETDATE())
Any help is appreciated.
{count} votes
-
Viorel 121.3K Reputation points2025-04-09T06:39:30.1066667+00:00 Maybe the
(DT_WSTR, 4)part is not needed? -
Ali Ahad 131 Reputation points
2025-04-09T11:01:07.38+00:00 I got this error message:
-
Viorel 121.3K Reputation points
2025-04-09T11:12:43.8966667+00:00 Maybe the parentheses will help:
(DT_WSTR, 4)( MONTH(GETDATE()) == 1 ? DATEADD("YEAR", -1, GETDATE()) : DATEADD("YEAR", 0, GETDATE()) ) -
Ali Ahad 131 Reputation points
2025-04-09T12:38:48.54+00:00 Truncation error message:
-
Ali Ahad 131 Reputation points
2025-04-09T13:50:59.81+00:00 I finally figure it out
(DT_WSTR, 4)(YEAR(MONTH(GETDATE()) == 1 ? DATEADD("YEAR", -1, GETDATE()) : GETDATE()))Thanks,
Ali.
Sign in to comment
Sign in to answer