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.