If you post the actual execution plans for the queries you detailed, it will be helpful to others.

SSIS is not going to perform raw data processing work any faster than the SQL Server database engine. In fact, it will usually be slower.

Therefore trying to move everything into...

Jeff Moden (2/24/2016)

---

I definitely wouldn't use XML for anything even close to this. Also, computers don't "easily" read XML. There are programs that make it easy for Developers...

peggy.carstens (2/24/2016)

---

I can write the SQL to pull both the header and detail records (duh!). It's the time it takes to pull the data that's the issue. Is...

donstarter (2/24/2016)

---

Thanks for your input Phil,

Yes, I can see the difference of the strings when pasting into Notepad++ kind of same as I see the difference when doing a hashbyte....

jasona.work (2/24/2016)

---

So a question to everyone: Would you prefer if someone posts a quick "reported as spam" reply to the spam topics after they report them, or nothing? ...

donstarter (2/24/2016)

---

Hi all,

I am having an issue with using distinct on one single column in a table and getting multiple result rows for a string "looking" the same. When I...

peggy.carstens (2/23/2016)

---

I have a large Sybase database that has 150M+ claim (header) records and 190M claim line (detail) records. We want to bring over the last 3 years of...

Jeff Moden (2/23/2016)

---

Heh... good grief. 1500 nodes. And it's not flat. It does...

Any XML gurus out there who would like to help?

http://www.sqlservercentral.com/Forums/Topic1763386-3412-1.aspx

--Edit: fixed garbage English!

OK, maybe this works...

astrid 69000 (2/23/2016)

---

Hi,

I take data from different xml therefore the structure may vary, and I need to bring it to a table so the data science can run a statistic...

VoldemarG (2/23/2016)

---

I am doing a typical Query --> Flat File in my SSIS package.

However I cannot output the file in the right format ( the format that is shown on...

jcachado (2/23/2016)

---

Ok, sorry but the error is common on both platforms and the error should be the same and the way to solve it 🙁

Thank you in advance for your...

astrid 69000 (2/23/2016)

---

Hi,

I have a table who have a number of columns. One of the columns contains an xml.

How can I parse the xml into column using the origin table...