OK, give all of that then I would say that SSIS is probably your best bet.

That said, don't expect it to be a walk in the park, SSIS...

I don't see your illustration. Did it get lost somehow?

{ deleted: duplicate post ...}

Do you/your company already have something that sends XML to the API and/or receives XML docs back from it? Not necessarily SQL Server, just something that already works that you...

You ask a lot of questions here, and I can only answer a few right now.

Brian Souder (5/16/2012)

---

2) I was trying to recalculate the database size after the 32-bit...

Yep. Developer Edition is only *almost* free....

Yes, that's right (sorry I didn't see this sooner).

One note is that you should make sure that the DB in question really IS trustworthy, as there are security implications to...

Right, a separate post, with a data set (million rows, of...

Jeff Moden (5/24/2012)

---

dwain.c (5/24/2012)

---

Jeff Moden (10/24/2010)

---

For the simple task of sorting in the correct order, we'll use the "Hierarchical Path" method. To build it, we'll use a "Recursive CTE"....

vinu512 (5/4/2012)

---

I give up...I've banged my head on this for really long....I have come to the conclusion that a loop cannot be avoided in this scenario.

However un-SetBased( 😛 ) or...

The questions that make the biggest difference in which way you go are probably:

1) What the current available skillset is there, and

2) What kind of responsiveness...

I saw something like this a long time ago. As I recall it had something to do with the code page settings on the clients.

It's never really bothered me either though. Given the number of disreputable consultants I've crossed paths with, I find it perfectly reasonable that potential customers have "trust issues". ...

SQL Kiwi (5/25/2012)

---

Several parallelism operators in the parallel plan have a warning symbol to show you that exchange...

Agreed. This is SOP almost everywhere I've been.