Linda 44925 (11/4/2010)

---

THanks ... ok then this

SELECT Projects.ProjName, (Employees.EmpName) AS EmpName, SUM([Employees Project Log].Hrs) AS TotalHrs

, RANK() OVER

(PARTITION BY Projects.ProjName ORDER...

How are you determining if your configuration is usable or not? If you are trying to verify if a connection can be established or not, I would recommend using...

What is the value of N? Peter's approach is a good one, but from my experience it can be very time consuming to configure everything to work programmatically -...

I would definitely remove the chart. I also typically convert my excel files to CSV files. If I'm getting files from business, I request that they are in...

There is a solution property called Run64BitRuntime. You can set it to false to run in 32 bit mode. Note - I wrote 32 bit, not 34 🙂

I agree. ...

Hard to completely understand your problem, but:

Create a Class Dimension. ClassKey will be included into your fact table which will indentify which measure is being used.

PugMaster (7/7/2010)

---

Hi

Sorry datawarehouse newbie question! I am not sure how to maintain the relationship between Fact and Type 2 Dimension.

i.e if a new row is inserted into a dimension table...

I've run into the same thing, although in a slightly different application. I built an ODS using the merge statement for each of the tables that were needed for...

Thanks for the additional info, but this is still difficult to diagnose without more information. My advice would be to create a test package and get rid of everything...

It sounds to me like it is a problem with your lookup(or Execute SQL Task that is used to insert records into your table) and not your update statement. ...

I use master packages in virtually all of my projects. You need to create your master package and then use the Execute Package task that will call of your...

How do you know the true value of your dirty data? For example, how do you know if...

Are you using package configurations or an expression for your connection manager to the file? Sounds like your package is reading the hardcoded path in BIDS, but then reverting...

Year and month only isn't an acceptable form of a date datatype in SQL Server. You'll have to store a day too (I just default it to the first...