SSIS OLEDB COMMAND RULES

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.".