Datawarehouse or Business Intelligence

I know this is a post from last year but it is worth a look.

http://www.sqlservercentral.com/columnists/vRainardi/businessintelligenceordatawarehouse.asp

Ms Build - A Start

I have been getting some questions about MSBuild so here is a start.
I hope to look into creating a wrapper app for our MSBuild/DBPro projects very soon.
http://msdn2.microsoft.com/en-us/library/0k6kkbsd.aspx

SSIS - OLE DB Source Component - Stored Procedure Error

Here is something we recently ran into when using a stored procedure inside OLE DB Source Component.

A change was made to a stored procedure that was originally working and providing SSIS OLE DB Source Component with all of the mappings and meta data. After a change to that proc, the mappings could no longer be validated and the meta data was not available. when configuring the component were suddenly not seen. What happened...?
Apparently the proc was changed in such a way that the original use of a table variable to store some temp results was removed and replaced with a #temp table. This stopped the transmission or access to the metadata from the proc. After some searching Dave M. was able to find this post http://blogs.conchango.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx

I added the SET FMTONLY OFF and tried to validate the SQL, SSIS did not like this and it threw an error. The proc was being called with 2 parameters and I could not validate with the SET FMTONLY OFF hint and the two parameters present. So what did I do...???
I punted...
Actually the proc was changed back to using the table variable and all is working again - after a host of other issues.

I plan on working on this again this week and will test out various methods to find a workaround that suits our needs. Stay tuned.

Like a termite in a termite mound

They have just started a program here at work that forces us to change our network log on password. Now I know what your thinking, they are just doing this now???? Scott it is 2007!! I know it is a big company and change happens slow which supports my discussion. I spent 10 min yesterday and signed into the program to create my own new password; a password of my own choosing - with the mandatory mixture of numbers and letters. My point is from the first time I had to re-log on to my workstation to the most recent time, I just cannot break out of the habit of typing in my old password and realizing, the moment I hit the enter key, I have become a termite in the termite mound. Merely a worker siding creativity for compliance and redundancy; I am now scared! I always took great pride in being creative, a go-getter, passionate, driven and now I see I am loosing a lot of that edge that got me to where I am now. I need something refreshing - maybe a vacation in Vegas!