SSIS was designed to be like Power Center, which also has a lot of buggy stuff if you don't follow thier ETL rules.

I like SSIS becuase it solves Many issues...

I have run into problems with this myself.

They all went away when I decided to just move each file to an Archive folder in the ForEach Loop, and...

"without trying to trick someone"

That...

Richard Warr (4/27/2011)

---

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in...

Nice question Steve.

We never have to guess or debate an answer with you.

Here is some psuedo code for a correct leap year test calculation.

if year modulo 400 is 0

then is_leap_year

else if year modulo 100 is...

Rune Bivrin (4/25/2011)

---

Being someone who actually used sp_addtype "back in the day" I wasn't surprised. The nullability is an attribute of the actual column. How the type is defined only...

I see a lot of churn, but no messages from Iianvh on if anything at all that anyone has recomended is working or a good fit for him.

Has...

Grant Fritchey (4/26/2011)

---

So they don't trust me to work from home, but they give me the keys to the kingdom for the enterprise data, and probably the HR & Finance...

Jason Selburg (4/25/2011)

---

One more time. 🙂

Can you agree that both of these code snippets SHOULD do the exact same thing! (Delete a random set of 9 rows)

but they do NOT....

Jason Selburg (4/25/2011)

---

The behavior displayed here does not occur with temp tables, only table variables and NEWID(). That is what is being shown here.

The "logic" of the code makes...

Jason Selburg (4/25/2011)

---

**YES THIS IS A TRICK QUESTION**

It's intent was to get you thinking, and spark conversation on the validity of Microsoft's statement that this is by design and not...

I would say you comprehended just fine.

I would also...

QOTD reference says

Which matches what I expected and what...

Been doing something similar to this for the last Six Months. I have found that the Database Edition of Visual Studio (2005, 2008, or 2010) has been invaluable in...