You can use SQL Server Profiler to monitor all the queries against your cube.

With the right options specified, you can filter out most of the events that you don't need.

But,...

Forget about my previous post. I've tried to convert the number using the time_t specification, but it gives an overflow. Which actually makes sense. There are about 31536000 seconds in...

Try adding another backslash to your file folders. Example:

d:\samples\

I think the problem lies in the fact that when the cube is processing your fact table, he will link the surrogate keys (or attribute key, whatever you use) to...

Is your dimension usage set-up correctly? (one of the tabs in the cube)

I usually forget this when I create new measure groups and dimensions and it can really mess things...

Regarding the set-up of hierarchies and attribute relationships for your time dimension, make sure you use the concatenation of year and month as primary key for month. For example: 200911...

Can you try the following query:

SELECT tt1.ID, tt1.ID_Count, tt1.Amount, tt2.ID_Count, tt2.Amount, tt3.ID_Count, tt3.Amount -- and so on...

FROM

(SELECT ID, COUNT(ID) AS ID_Count, SUM(Amount) AS Amount

FROM t1

GROUP BY ID) tt1

INNER JOIN

(SELECT t1ID,...

clucasi (2/18/2010)

---

Does anybody have an idea if you can use raw files to update records in a table using SQL server 2005

I have trawled the internet but with...

Or you can use the following SQL code in your OLE DB Source:

SELECT

t0.[ID] AS [ID]

, [Name]

, (isnull(TOTALCOD1,0) + isnull(TOTALCOD2,0) + isnull(TOTALCOD3,0)) AS TOTALSUM

, TOTALCOD1

, TOTALCOD2

, TOTALCOD3

FROM

(SELECT [ID]

,[Name]

FROM...

Aaron Cabrele (2/17/2010)

---

Hi

I have the exact same problem, however my source file has 1200 columns which is being split into 2 tables so it is not feasable to go through...

Such a...

Can you give an example of how SSIS sees the input data?

My first guess is to convert it with a Data Conversion...

Maybe you could try the following...

Steve Jones - Editor (2/16/2010)

---

I think the best practice for learning a variety of things is to troll forums like this one (or the SSIS one) and answer questions. Figure...

Glad that you resolved the issue.

darshan-987176 (2/16/2010)

---

The Initial catalog name i.e the OLAP database server name was mentioned wrong for the cube processing task. And the OLTP connection used wrong...