SSIS Errors - Part 2

While transfering the data from Source to Destination, if there is data type mismatch we used to get the following error.
Messages
* Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".

The problem is with the matching columns between source and destination

Considering am having id column in source as varchar(10) and id column in the destination is int. Then if we try to execute the package.Obviously, we will get an error.

Solution: 1. We need to change the data type in the source table.

2. We need to write some conversion scripts for varchar to int type for the id column. You can prefer Derived column task to do this conversion.

Happy Learning!!!

Regards,

Venkatesan Prabu .J