mic.con87 (12/7/2011)

---

I tried your code and still no luck:

Error message I receive is:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'ClaCaseID'.

Msg 156, Level 15, State 1, Line 3

Incorrect...

mic.con87 (12/7/2011)

---

So seem like I'm back to the drawing board....

SELECT MIN (cc.ClaCaseID) KEEP (DENSE_RANK LAST ORDER BY rl.YearOfIncident) AS latest_cla_case_no

...

Nice question, learned about iso_week.

It would have been better if the dates were in ISO format, but that's just a detail.

You could derive the answer immediately if you just found...

hxkresl (12/7/2011)

---

But Guess What, Charmer? I have another problem and I bet you can help me 🙂

Dataflow tasks are as follows:

OLE DB source -> OLE DB destination

The source is...

Dev (12/7/2011)

---

It's not...

msbi2049 53516 (12/7/2011)

---

Hi,

User: Source queries (Data type is Object) variable is we have created manually and Total package Source Queries is stored in that variable. @CustmeorID...

Wow, another excellent question Hugo. Thanks!

We're getting somewhere. The variable @user:source queries, how is it populated? How many columns does the resultset have and what are their datatypes?

What is the datatype of the @CustomerID variable?

I would have used SSAS tutorial as keywords for Google...

So if I'm guessing it correctly, you have a For Each Item loop?

Which columns did you define and what are their datatypes?

I'm not following. Which question are you trying to answer?

I'll ask the question again: how do you populate the CustomerID variable?

It is better to stick with one thread, instead of posting your question in various threads. That way replies will get fragmented and it can waste people's time.

Question with replies...

hxkresl (12/4/2011)

---

Jeff,

would you consider looking at one more issue? I just added another column to the excel source so that it would map to an existing varchar (15) column...

chris.stuart (12/5/2011)

---

Jsut that the input column lenght is not the same as the reference column lenght. I know, not the end of the world, but...

But as mentioned, if selecting the...