• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2369
  • Last Modified:

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.  DataFlow
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
Error Description
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!
0
rmm2001
Asked:
rmm2001
  • 3
1 Solution
 
rmm2001Author Commented:
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!
0
 
rmm2001Author Commented:
What happened with this is that the XML in my package wasn't updating the data types. I had to manually go inside the file and update from there.
0
 
rmm2001Author Commented:
Complete
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now