package variable error

Question

Hi Experts,

unable to figure out this error.

Answer 1

I think the variable v_Updated_Date is of type DT_I4 so you would need to cast it to varchar before you do the concatenation
So modify the expression like

"SELECT store_name
FROM src
where update_date > '" + (DT_STR,20,1252) @[User::v_Updated_Date] + "' order by rtl_loc_id"

Answer 2

The entire SQL Statement expression is of a UNICODE data type. That's why a proper casting is below:

"SELECT store_name
 FROM src
 WHERE update_date > '" + (DT_WSTR,20) @[User::v_Updated_Date] + "' ORDER BY rtl_loc_id;"

Answer 3

Hi @San ,

We can use the following methods to solve this question:

Method 1: Using Type Casts (DT_WSTR, <<Length>>) in expression builder.
Expression1:
"SELECT store_name
FROM src
WHERE update_date> '" + (DT_WSTR, 10) @[User::v_Updated_Date] + "' ORDER BY rtl_loc_id;"

Method 2: Changing the Data type of variable [User::v_Updated_Date] as String.
Expression2:
"SELECT store_name
FROM src
WHERE update_date> '" + @[User::v_Updated_Date] + "' ORDER BY rtl_loc_id;"

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.