Hi Experts, I have an SSIS Package that is loading an Excel file into an SQL Server Table.
However I do have a problem with one column.
On my source Excel file I have a Column called "ProductsInNeed" and the datatype is like (DT_WSTR with a length of 255)
and the values in that column are like
On my Target Table I have 6 columns like
All columns are with Datatype Varchar with a length 255.
What I have to do is like I need to check for a string in the incoming column
If I have a string "Toner" in the source column then I need to send That to the Target Column
"TonerWanted" or else I need to send in a NULL
For this I have written an expression in DerviedColumn Like this
TRIM(FINDSTRING(ProductsInNeed,"Toner",1) == 0 ? "Toner" : (DT_STR,255,1252)NULL(DT_STR,255,1252))
But I am getting an error Like this
[OLE SRC ] Error: There was an error with output column "ProductsInNeed" (3112) on output
"OLE DB Source Output" (11). The column status returned was:
"Text was truncated or one or more characters had no match in the target code page.".
Any help on this will be Highly Appreciated.... Thanks In Advance