The oledb commad transformation prepare the wrong data type for the parameter.
With my test, I have known something about the rule. You write query like
Charindex(fileld_name,?)>0 the it will employee a inteter for you because the >0.
If you use cast(charindex(field_name,?)>0 as varchar(255))='0' it will use a DT_STR
With a length of 1. Just for your '0'.
At first I want to change the data type by myself, but it will change back automatically.
After I check this in MSDN, I know that you can not change the Param_x 's name and data type.
You can treat it a bug, but It is hard to check the right data type, so you should take care
For its this character.
I do this in BIDS 2008, Mabe it is ok for 2012 or 2014 CTP.
[OLEDB_UPDATE SRVR_DN [20]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E21 Description:
"Invalid character value for cast specification.".
