If you don't want it to actually fail if the lookup doesdn't work, then use the "redirect row to no match output" option, rather than the "redirect rows to error...

Jeff Moden (2/21/2012)

---

Heh... one thing I've learned is that there's a whole lot more apathy on the subject than all the fanfare on by Google, WikiPedia, and folks on various...

Actually, you could simply flip the comparison around a bit and do it without the OR or the ISNULL.

(Code removed after double-checking).

Edit: hmm - foiled again. The result...

Steve Jones - SSC Editor (2/20/2012)

---

The questions are framed in a strange way to me, since my blog is mine, not shared.

I wouldn't have voted for a SOPA bill that...

SQLKnowItAll (2/20/2012)

---

EDIT: Isn't that the...

I think this is a logic flaw. Your update is against the virtual server table, but you're left joining against that table and specifying you want to exclude those...

emmchild (2/19/2012)

---

Internal operations are a cost center. The business view of cost centers is that this functionality can be out sourced. The folks watching the bottom line will...

Joe Johnson-482549 (2/17/2012)

---

If you find an excellent developer, you can get the best, most sublime code... that you still need to sale. You find a salesperson that can sale...

We finally achieved 4-9s uptime this year, up from 3-9s last year! The new DBA rocks! That's 9 less hours of downtime spread over a whole year. (That's about 1.5...

That means you have instances of elements with text AND sub-elements.

So - this would be an example:

<myBadNode>

This is...

ismailmallum (2/16/2012)

---

Hi,

With SSIS 2005 you can only import 1 column at a time using the XML source component. i know 2008 handles the XML better so for now rather than...

Use SSIS. It will allow you to simply ignore conversion errors, and even log them if you wish to

Or SSIS could do as well.... hard to say without any specifics.

Is there a reason to import the XML this way? If you were to use SSIS on the source XML file you wouldn't be having to play some outlandish...

Koen Verbeeck (2/14/2012)

---

Matt Miller (#4) (2/14/2012)

---

ACtually - using an ORDER BY during the insert would guarantee the ID's be generated in the correct order. Conor Cunningham confirmed that to...