Read Ralph Kimball's book: The Data Warehouse Toolkit

Also, there's tons of good information on his web site at:

http://www.ralphkimball.com/[/url]

Cubes are generally used for analytic reporting against large volumes of...

OK...if we're on to books...here's another one...

How about the "Fantasy Game" from Ender's Game?

It knows all of your weaknesses and fears and plays on them and then ultimately evolves into...

OOOHHH! I have to add one on the subject of "portrayed realistically"...

Jeff Goldblum's laptop in Independence Day. He was able to tap into totally alien computers and operating...

Wow...lot of great ones so far. I've got two more.

The M5 computer from the episode of Star Trek where they upgraded the Enterprise's computer with the system that started...

Years (and jobs) ago, an interoffice joke circulated that was a list of IT Terminology. The only one I remember from it was the definition of "DBA":

"No one knows...

If you want to do this in the package you'll have to do it with a script task.

You'll need a derived column for any constant values and you can only map one input column to one output column in the destination so you'll need to do a...

When you say "nothing happens" do you mean that when you run the package in VS, everything turns green and there are no error messages?

Is there any useful in formation...

You should be able to cause your package to write out anything you want to the log using script and the DTS.Events.Firexxx methods (i.e. FireError, FireInformation, FireCustom, etc.)

You can not pass parameters directly to an Oracle OLE DB Source in SSIS, you must build the SQL dynamically in a SSIS variable and use the SQL Command from...

Setting TransactionOption to required means that the task MUST have a transaction. If one is already started, it will join to it. If none already exists, it will...

I guess it all depends on how often he'll need to run it and if this is a production process or just something that needs to be done during a...

Hmmmm...not sure why that might be but I would recommend that you look into SSIS package logging. It's much more robust than DTS and you can standardize logging and...

I use a series of stored procedures for logging my package execution results. I keep row counts in variables as you describe and then log the results to a...

Simple answer: Right-click the error line in the Execution Results tab, click "Copy Error Message Text" (or something like that) and paste it into Notepad.

Slightly less simple answer: Turn on...