Solved

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

Posted on 2011-02-11
4
2,140 Views
Last Modified: 2012-05-11
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
Comment
Question by:rmm2001
  • 3
4 Comments
 
LVL 15

Expert Comment

by:MohammedU
ID: 34876256
0
 
LVL 7

Author Comment

by:rmm2001
ID: 34876903
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
 
LVL 7

Accepted Solution

by:
rmm2001 earned 0 total points
ID: 34899022
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
 
LVL 7

Author Closing Comment

by:rmm2001
ID: 34936425
Complete
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now