Cancel a build/deploy

April 27, 2006

Maybe I'm the only one that didn't find this right away, but I'll blog about it anyways.

Anyone needed to cancel a deploy/build?  Sometimes my project defaluts back to deploy and build and I only want it to deploy causing me to need to stop the deploy.

Go to the Build menu and a new menu item is there during a build called cancel.

Have fun.



Dimension Hierarchy Relationships

April 25, 2006

We all (should) know that it is really important to set up relationships between our dimension attributes.  This enables AS to build aggregations at levels other than the top and the bottom.  For a large cube this could make a huge difference in query speed.  I haven’t found a really clear example of how to set these up so I thought I’d take a stab at it.

When you are editing a dimension hierarchy, you need to add a parent relation ship to all levels.

If you have Year, Month and Day (and a Key) you need to add a releationship to Year in the Month level and a relationship to Month in the Day level and then over on the left, add a relationship to the Key from the Day level.

Every level must have its parent defined as a relationship.

In addition to that, don’t forget to make sure that the relationship type is set up properly.  In this example, we have a rigid hierarchy since we know that no members will be moving around like people in an organization.  March of 2003 will always be a 2003.  Each relationship need to defind whether it is a many-to-one or a one-to-one relationship.  In this example, they are all many-to-one except for the relationship of the key to the Day level.  This would be a one-to-one.

Hope this helps.


Adventure Works OLTP

April 25, 2006

In case anyone was wondering, the storefront for Adventure Works can be found at

\Program Files\Microsoft SQL Server\90\Samples\Integrated Samples\Storefront

I was looking for it and had a little trouble finding any info on the web.

Thought I'd blog about it so others won't have to search.


SQL Server 2005 Samples

April 25, 2006

I just ran across the SQL 2005 samples and noticed that they had been re-released.  They are now dated 4/19/2006.

Not sure what is different – there isn't a readme that specifies.

Thought I'd let everyone know they seem to have been updated.



SQL Server SP1

April 21, 2006

SP1 is out.  Check here for the bugs that are fixed and here for the enhancements.

Go here to get sp1.




April 18, 2006

Ran across this website today.  This group has made an AJAX (Atlas) based thin client to SSAS 2005.  I would love to see it.

SSIS Recordset Destination as Source?

April 14, 2006

Ever wanted to put some data in a Recordset Destination and then pull the data out at a later time in your package?

Sorry.  No can do.

You can foreach through the record set and act on it in that way, but if you want to use it as if it were a source, no luck.

A Recordset Destination gets it metadata at design time from its predecesor.  A recordset source wouldn't have that opportunity to set metadata.

You'll have to use raw files instead.  Dump the data out to a raw file and then use a Raw File Source later in your package.

Seems like a workaround, but that's the way it is.


I just read a blog entry by Jamie Thomson (click here) and was interested to hear him say that the raw file adapter was designed for passing data between two different data flow tasks.  He also talks about a way to create a script task as a source that loops through the recordset in memory and plops each row in the pipeline.  Very clever.