OLE DB provider error: Invalid character value for cast spec

[dr.murthy]

Hi,

Am just trying to load the data into Table by using SQL Server stage(Target database), a simple job having three stages fetching data from file loading into table Transformer is placed between . none of the records got loaded into SQL table got warning like : OLE DB provider error: Invalid character value for cast specification.


could you please any one help out this.
NOTE: no transformations and conversions are done in Trasnformer

[Sainath.Srinivasan]

One possibility is that you are trying to move a varchar to numeric or date field.

Check the flow.