Jan Van der Eecken (3/7/2012)

---

The issue was actually a very simple one. If one runs SQLFULL_x86_ENU_Install.exe, all it does is extract the files from the .box files. Stupidly I ran...

That will introduce another series of issues, the most important one is having...

That won't clean anything, unfortunately.

This page explains what is sensitive and what not:

Setting the Protection Level of Packages

What is the protection level of the package?

Or just store the username and password for the Oracle connection inside the configs.

And use DontSaveSensitive, it gives the least amount of issues.

(or just get rid of Oracle :-D)

Please do not crosspost. It wastes people's time and fragments replies. Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1262672-148-1.aspx

Is it me, or is this publishing copyrighted material:

http://www.sqlservercentral.com/Forums/Topic1262092-148-1.aspx

(if SOPA got through, this site could be taken down)

Duplicate post. Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1262092-148-1.aspx

You need to implement a lookup component to your destination Z to determine if a row is a new insert or an update. Filter out the updates and do only...

You can embed your reports in .NET using the ReportViewer control.

ReportViewer Controls (Visual Studio)

p.s.: that means you don't have to create an entire fact table on top of your dimension, just a calculated measure

Such questions are easily answered with the most basic SQL statements. So a report would do the trick quite nicely.

If you really want it in the cube, it's also possible....

Do you have a job that has no owner?

That's a very strange join condition. Why is that?

Do you mind sharing some logic behind these queries?