Whupty-freakin'-doo! This is an amazing article!

I have never heard of DATENAME before, so thanks for pointing it out Jeff.

I was real sad to see Donald Farmer leave MS BI.

I just saw him speak at an event at early december 2010, which isn't really a long time ago.

He had...

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!