And how do you know which FileID you need from the Files table?

Do you want to perform a lookup using the Fname and Lname columns?

tommyh (9/6/2010)

---

Hrmm having a hard time deciding if that is supposed to be sarcastic or not. But anyway.

I used "we" to represent everyone using SQL. Honestly...

tommyh (9/6/2010)

---

Because Microsoft havent implemented...

PSB (9/3/2010)

---

I got it .

((Contract_Type == "DS" ) && ( [Group/Name] != "") ? "DS" : (Contract_Type == "DC" ) && ( [Group/Name] !=...

How did you deploy the package to the MSDB folder?

A recommended read is the Data Warehouse Toolkit from Ralph Kimball.

Furthermore, you can take a look at http://www.sqlbi.com. They propose a methodology on how to implement your ETL/Data Warehouse with...

:-D:cool:

Alvin Ramard (9/1/2010)

---

stevefromOZ (9/1/2010)

---

In case you are looking to do this in SSIS and not SQL, you're looking for the conditional operator (which, if you used that in a google...

Nice question, but the explanation could be better, as Happycat already demonstrated.

Hugo Kornelis (9/1/2010)

---

Correct. That was April 14, and it was similar...

Nice question. But I believe I've seen a similar one here in the QotD (but I may be mistaken).

Well, I did a small test and it appears that you are right. SSIS will not execute the task if the precedence constraint is not met, even if the previous...

http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part1_p1.aspx

Some of the most important things of the ETL that you must document:

* data mapping (given a certain output column, which are the contributing input columns)

* information liquidity model: describes...

I think it is best that you include brackets, or otherwise...