Hi guys -
I'm having an issue with a dataflow task that i have. It's a pretty simple task. I have an oledb connection that selects all of the rows from a table. Then a rowcount transformation that just counts the rows and throws it into a variable. Then an oledb command that is an update statement that updates a table. Just a simple UPDATE table SET X = xx, Y = yy, etc WHERE table.ID = zz.ID.
I have 30 other packages that work fine using this structure. Except for this one. I keep getting this error:
The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid
I've rewritten the package who knows how many times and still can't figure out what else to do on it.
Any clues as to what I need to change to make it work again?
Thanks in advance!