Craig Farrell (1/18/2011)

---

For truncating use an Execute SQL task in the main flow.

For updating (especially UpSert) use the Slowly changing Dimension component. It's a wizard that will handle your...

You cannot connect to the data mining structure with an OLE DB source, you need an Analysis Services Connection Manager.

See the following links:

http://msdn.microsoft.com/en-us/library/ms141018.aspx

http://msdn.microsoft.com/en-us/library/ms141728.aspx

http://msdn.microsoft.com/en-us/library/ms139761.aspx

Are you copying data from Oracle to Oracle?

If yes, why don't you use Oracle Migration Workbench?

How do you read from the source?

If it is a relation source and you are accessing it with a SQL statement (you should), then you can just add an extra...

Brandie Tarvin (1/19/2011)

---

GAH. My boss figured it out.

Had to go into Dimension Usage on the cube screen, right click in the "white space" and add new cube dimension.

But I don't...

What is your point of posting this URL?

It doesn't even work.

OK, this was too easy, considered you already asked some questions about VLF's. 🙂

As said before, can't you just execute a TSQL UNION statement in an Execute SQL Task?

Jack Corbett (1/19/2011)

---

... I just assume...

At my place, job descriptions are...

Brandie Tarvin (1/19/2011)

---

I blogged once about who watches the watchers. Apparently, it really is becoming a big thing lately.

Security_fail_When_trusted_IT_people_go_bad?

Wow. The PDF referenced in the first page of this article has...

Allright, thanks!

If I have some spare time left I'll check it out.

edit: nice website btw

Nice and easy, thanks!

Thanks for the reference to the article Steve.

As a BI developer, I find it a very interesting read, but damn, it is quite a long article 🙂

But I've always found...

No problem, glad to help!