Evil Kraig F (7/21/2014)
Jeff Moden (7/21/2014)
I have to admit that using XML to do such a thing (and, yes, I have send data "over" for the very same reason you've suggested) would be the furthest thing from my mind except for maybe sending it as EDI. 😛Heh, well, to each their own, I suppose. I find it much easier (and more obvious for inheritors) than using a two stage splitter, particularly when in some cases I'm running a MAX transfer. I'm just used to it at this point, and find it relatively easy to setup.
Agree on the "to each their own" but I wouldn't use a 2 stage splitter for this. It's a simple data transfer similar to what replication would do. What's so bad about using something like BCP to export the data to a central transfer repository and simply import the data at the other side? Rhetorical question, for sure. Just another way to skin the proverbial cat.
--Jeff Moden
Change is inevitable... Change for the better is not.