Thanks Paul, some great ideas there.

Here's some short answers to some of those points:

1. The guys behind SQLDTS.com (Allan Mitchell & Darren Green) have brought out a new site, SQLIS.com,...

I'll list the changes that are important to me or that I am excited about, MS would doubtlessly prioritise them differently.

1. SQL Server Integration Services is the new version of DTS....

Win XP Pro on my stand alone desktop machine at home. Its basically only used by me as a filestore and by my girlfriend and lodgers as a web browser...

The DTS 2000 runtime will be shipped with Yukon so you can still run your packages. However, there is no provision for editing DTS 2000 packages.

HTH

Robert,

I don't know of any article that describes this but I can tell you what I know.

First, you have to get your head around a completely new paradigm shift in...

Good question, and coincidentally one that I was asked yesterday by a colleague upon reading the article.

You are correct, nested transactions are not supported. This would be an interesting feature...

Hi Arthur,

This will depend on whether there is an OLE DB Provider for your data source. Not knowing anything about mainframes I'm not the person to ask about this.

Alternatively, if...

I've just realised that this thread is over a year old. I hope someone reads it!!!

There was a link to it in the 2004-12-06 newsletter which is why I happen to...

There is another technique. Gert Drapers did a straw poll of the audience at one of his PASS presentations this year to see who knew about this technique and very...

That's not ringing any bells but then...why would it?

Appreciate the help! Thanks Craig. I'll be using that alot.

Sorry Nitin, I worded my original post badly. The methis I was shown makes it possible to do this without even shutting down SQL.

The commands are a couple of T-SQL...

You need something new or you need to modify what you have already. Many people's definition of a data warehouse differs. I like to think of a data warehouse as...

One of the best articles I've read on sqlservercentral. My eyes have been opened.

My compliments to the author!

Sure, the cube can still have aggregations but not on the p-c dimension.

I base this on the fact that I created a cube with 1 dimension - that being a...

Mark,

A worked example is probably better.

 

Imagine the following scenario. My organisation has a sales team that I am modelling as a parent-child (p-c) dimension.

 

Lisa is the Sales Director

Mark and Tim...