Thursday, March 16, 2006 - Posts

Are you up with Web 2.0

This really made me chortle. If you think you know about web 2.0 then you should do well

http://www.cerado.com/web20quiz.htm

posted Thursday, March 16, 2006 12:06 PM by SimonSabin with 0 Comments

SSIS doesn't do what I want

On answering posts in the SSIS forum I have noticed quite a few where the answer is use a script task/component.

Whereas with DTS the use of the activex script was painful the use of the script component/task in SSIS is a pure joy.

Why?

Because you have the full ability of a proper editor, intellisense, and all the lovely features of .Net, generics, string manipulation etc.

Recently I have used script components to achieve, reading a locked file, handling an unknown number of columns, doing a performan distinct operation (using aggregate requires all data to be processed before rows are output)

So if someone says use a script component in SSIS don't be concerned, this is not vbscript its VB.Net compiled code with all the wonders on .Net.

posted Thursday, March 16, 2006 5:24 AM by SimonSabin with 1 Comments

Advanced edition of SQL Express

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Advanced edition of SQL Express
The new RSS feed is here

I mentioned previously about an "Advanced edition of SQL Express" that was coming out. Well they were going to have a private beta but instead have opted for a public CTP. It seems it is going to coincide with a CTP for service pack1 of SQL 2005.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Advanced edition of SQL Express

posted Thursday, March 16, 2006 3:27 AM by SimonSabin with 5 Comments