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...

If you run the following query at the msdb database (one of the system databases) at your SQL Server, do you get any results?

SQL Server 2005:

SELECT [folderid]

...

Ragie,

I've had a similar issue not so long ago.

I was also looking for a clean way to 'exit the loop' if an error was found (similar to the continue statement...