The way you want it, TableB is the source and TableA is the lookup table. Period.

You can try to implement it with TSQL using WHEN NOT EXISTS to speed up...

Great question, thanks.

Fal (2/15/2011)

---

WayneS (2/15/2011)

---

Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem...

quillis131 (2/15/2011)

---

yes ...source and destination are on the same server...But i read in some forum, to replace sql dest with OLEDB dest...where it work out completly fine. But i want...

Roy Ernest (2/15/2011)

---

Dave Ballantyne (2/15/2011)

---

Big meeting on friday to best decide how to handover all my knowledge to co-workers.

First big change i need to do today is was told to...

michael.kaufmann (2/15/2011)

---

Anyway, I guess the best thing to do is to not use reserved keywords as identifiers for any database object. But then, who would actually use those as table...

Is the package running on the same server as the SQL Server Destination?

1. The syntax is as follows: (boolean_expression) ? expression_if_true : expression_if_false

2. There is no IsNumeric function in the derived column, but you can build it with a script component:

http://consultingblogs.emc.com/jamiethomson/archive/2007/05/03/SSIS_3A00_-Checking-for-IsNumeric_28002900_.aspx

3. What...

Easy question.

But what's the deal with QUOTED_IDENTIFIER, because the statements works whatever it's setting is.

(was it a distraction from the real question?)

You can also script out dtutil to move packages from one server to another.

http://msdn.microsoft.com/en-us/library/ms162820.aspx

djordan 4543 (2/13/2011)

---

after about 5 months the boss signed off on licencing for sql 2008 R2 last week. Should be able to install the licence for expiry date next Saturday!

thank...

Craig Farrell (2/13/2011)

---

It's sad. I think the first thing that dies in a time crunch is documentation. That's not that unusual and can be frustrating a few years...

Congratulations!

I had to think long and hard on this one 🙂

(but apparently, at the time, 3 people already got it wrong)

Happy Valentine's Day!

Tom.Thomson (2/12/2011)

---

Koen Verbeeck (2/12/2011)

---

The Dixie Flatline (2/11/2011)

---

QA is where some developers send their code to see if it works correctly or not. Often they do this without verifying...