SSIS, TVP: An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E21 Description: "Invalid character value for cast specification"

Error:

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E21 Description: "Invalid character value for cast specification".

Cause:

Not fit parameter declaration.

But:

If your all parameters were declared well, but you still have this error, and one of the parameter is a TVP (Table Variable Parameter):

The TVP is the cause...

I tried to pass a SSIS Object to TVP in the stored procedure, and I've got this error.

Solution:

I pass the data to a temp table in the destination DB, and took it from there to the SP.

SSIS error: The SQL command requires a parameter named, which is not found in the parameter mapping

SSIS error message:

The SQL command requires a parameter named "@aaaa", which is not found in the parameter mapping.

Cause and Solutions:

1. The parameter is really not exists. Solution: declare it.

2. Space - " " - in the mapping pf the parameter - see the picture below. Solution: delete the space.