Welcome to MSDN Blogs Sign in | Join | Help

June 2007 - Posts

Friday, June 15, 2007 9:07 AM

Optional date parameter

This was part of the solution to the project my team was working on (that I'm still in the process of writing up), but I thought I'd post it separately because it has various uses. The Problem We have a package which does some aggregations based on a
Posted by mmasson | 4 Comments
Tuesday, June 12, 2007 9:01 AM

SSIS tutorials on JumpstartTV

I just wanted to call attention to the great SSIS tutorial videos that can be found on JumpstartTV . I find myself referring new users to them all the time. The majority of them were created by Brian Knight , but there are also a couple up there by Ira
Posted by mmasson | 4 Comments
Filed under:
Monday, June 11, 2007 7:33 AM

Data flow improvements in Katmai

As I previously mentioned , the current Katmai CTP contains a pretty major reworking of how data flow tasks get executed. Michael Entin has written up an overview of the changes that should be of interest to any long time SSIS users.
Posted by mmasson | 1 Comments
Filed under:
Thursday, June 07, 2007 9:40 AM

SQL Native Client 10 - provider name change

The provider name for SQL Native Client (SNAC) connections has changed in Katmai. Since this is the default provider for OLEDB connections, you'll probably be affected by this change if you're running SQL Server 2005 packages in Katmai. Version Provider
Posted by mmasson | 0 Comments
Filed under: ,
Wednesday, June 06, 2007 11:46 AM

Select variables dialog

A nice convenience feature in the new VSTA based script task is that we now provide a variable selection dialog for the ReadOnlyVariables and ReadWriteVariables properties. Ok, so there's not much content in this post. I admit it - this was just a reason
Posted by mmasson | 1 Comments
Filed under: ,
Tuesday, June 05, 2007 4:39 PM

Katmai - Script tasks which use the SSIS object model

[ Edit: Note, this has been resolve in current Katmai CTPs ] You may run into issues in the current Katmai CTP if your script task uses objects contained within the ManagedDTS assembly. If you're interested in the details, keep reading - otherwise you
Posted by mmasson | 2 Comments
Filed under: ,
Tuesday, June 05, 2007 4:05 PM

Katmai - Custom components and upgrade

(Note, when I use the word "components" in this post, I'm referring to all extensible items, including tasks, pipeline components, foreach enumerators, loggers and connections) The first major change I worked on as part of the SSIS team was re-versioning
Posted by mmasson | 8 Comments
Filed under:
Tuesday, June 05, 2007 8:06 AM

First public Katmai CTP

The first public community technology preview for SQL Server 2008 (code named Katmai) was announced at TechEd yesterday, and is now available for download. You can register here to download the developer editions, and post questions / comments / concerns
Posted by mmasson | 1 Comments
Filed under: ,
Friday, June 01, 2007 10:14 AM

Real world scenarios

May has been a busy month! The first Microsoft Business Intelligence conference was earlier in the month, and it seemed to be a big success. I was amazed at how many people were there, and I met a lot of interesting people when I was manning the demo
Posted by mmasson | 2 Comments
Filed under: ,
 
Page view tracker