Learned something new, thanks Steve

Thanks for the question Hugo.

Thanks for the question. I never used nullif before however I do recall seeing it in some Oracle sql before.

Nice question Hugo! You got me on this. I didn't think it through. Considering the failure rate on this question, I would say that you enlightened a few people with...

David Data (6/13/2012)

---

Having built a fairly big SSIS application, I find that as I add functionality, I no longer add further SSIS task boxes. Instead, I add to the...

Koen Verbeeck (6/13/2012)

---

Thanks Koen, this article looks pretty thorough!

Welcome to SSC!

I prefer Merge statements versus performing everything via SSIS tasks. I use lookups as well but find that they bog down with larger data sets. Most of my packages still...

Great question and dialogue. Thanks!

Thanks for the SSIS question Koen. And a 2012 one at that!

L' Eomot Inversé (6/7/2012)

---

Nice straightforward unambiguous question.

Of course it's about a nonstandard implementation of something designed to query the overhyped and much misused XML format, with which sensible people want...

Thanks for the question! I don't think I will ever use XQuery either but it's good to research these things anyways.

Interesting. Good to know, thanks Lynn!

Thanks for the question. I was worried that the help file would be online only as well. I was a bit annoyed that I had to download it since I...

Thanks for the question about a new feature.