Link to home
Start Free TrialLog in
Avatar of rmm2001
rmm2001Flag for United States of America

asked on

SSIS The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid

Hi guys -

I'm having a bit of a package crisis. I'm using SSIS 2005. My dataflow looks like this.  User generated image
But it errors out half way through (the recordset is ~12k that I'm sending through). ALL of the rows error out. And there's no reason for them to. But SSIS gives me this error message when it crashes: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid.".

When i put a data viewer right after the Update box (which is just an UPDATE table set X = Y where Y is the dataset from the oledb source)...which worked fine up until a few days ago. Here's what I get with the data viewer
User generated image
I can run the update by hand and all is perfectly fine.

Any thoughts as to why I'm suddenly getting this? I've rebuilt the package too, and that hasn't seemed to have fixed anything.

Thanks!
Avatar of rmm2001

ASKER

Those really weren't in re to my question (sadly). Do you know anything what SSIS means when it says Hresult: 0x80040E14  Description: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid.". ? Or even how to fix it would be grand!
ASKER CERTIFIED SOLUTION
Avatar of rmm2001
rmm2001
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rmm2001

ASKER

Complete