Dev (12/9/2011)

---

Koen Verbeeck (12/9/2011)

---

I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new" in Belgium).

So...

I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new" in Belgium).

So now I have access to...

Evil Kraig F (12/9/2011)

---

Because Basement-Cat made IE.

I apparently need to...

Eric Klovning (12/8/2011)

---

First you need to identify the business key, the column or columns that make the data unique in your source system. You say pDate and PType are identifiers...

PaulB-TheOneAndOnly (12/8/2011)

---

Olalekan Adewale (12/8/2011)

---

- My question is how can I place SCD type 2 on email column?

- My approach of updating the table is truncate and load, what other best...

Koen Verbeeck (12/8/2011)

---

Cadavre (12/8/2011)

---

Koen Verbeeck (12/8/2011)

---

Hmmm. When I click on the Forums link on the homepage, I get the maintenance page.

(http://www.sqlservercentral.com/Forums)

However, the link http://www.sqlservercentral.com/forums - with a lower f -...

Indeed. So thanks for the easy point! TGIF

Revenant (12/8/2011)

---

Koen Verbeeck (12/7/2011)

---

:w00t: Easy one! Thanks!

It should be easy to test.

WITH CTE_Numbers (number)

AS

(SELECT ROW_NUMBER() OVER (ORDER BY sc1.name) AS number

FROM master.sys.columns sc1, master.sys.columns sc2)

SELECT TOP 32767 'CREATE...

It's also 1/3 SSIS 😀

The MCTS exam for BI...

Money money money money.

Oh, I'm sorry, you were saying? 😀

Here in Europe there is enough work for IT people. Recently there was an article in...

imani_technology (12/8/2011)

---

Ah, I think I get it! I was making things too complicated, I guess. Let me see if I understand at the high level.

1. I use...

For SSIS, there isn't really a change between 2008 and 2008R2 (just a small one in ADO.NET connection manager if I'm not mistaken). So if select BIDS during the install...

Brandie Tarvin (12/8/2011)

---

Try flushing your eyes. And if that doesn't work, try flushing your brain.

It can't possibly be the site. Websites never...

Cadavre (12/8/2011)

---

Koen Verbeeck (12/8/2011)

---

Hmmm. When I click on the Forums link on the homepage, I get the maintenance page.

(http://www.sqlservercentral.com/Forums)

However, the link http://www.sqlservercentral.com/forums - with a lower f - works.

The forums...

The OLE DB Source editor is used just to select data. You can do a comparison by joining the two datasets (source and destination) on the business key using a...