Very nice question. Had me thinking for a while.

Well, the error is quite self-explanatory:

SSI cannot implicitly convert a string encoded in unicode to a string encoded in another coding schema (or the other way around).

The solution is simple:

convert...

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