Cannot convert Date in SSIS Expression builder

Question

SSIS expresion builder I have cast error cancnot convert string to datetime

"SELECT *
  FROM table Where OperatingDayDate>='"+@[User::MaxOperatingDayDateTime]

ERROR : CANNOT CONVERT STRING TO DATETIME

MaxOperatingDayDateTime IS variable DATETIME in SSIS OperatingDayDate is type DATE

If you press Evaluate in the Expression Builder, what SQL query is returned? — userfl89, Apr 01 '19 at 15:28

score 1 · Answer 1 · answered Mar 28 '19 at 19:29

1

You have to cast the variable data type:

"SELECT *
  FROM table Where OperatingDayDate>='"+  (DT_WSTR,50)@[User::MaxOperatingDayDateTime] + "'"

One thing not mentioned, if you are using the SQL command in OLEDB Source you can use parameterized query:

SELECT * FROM table Where OperatingDayDate >= ?

answered Mar 28 '19 at 19:29

Hadi

@Yasirayub what have you tried? The first or second method? – Hadi Apr 01 '19 at 16:56

1 Answers1