Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Friday, November 13, 2009 9:38 AM

Handling Slowly Changing Dimensions in SSIS

I had a great time at PASS last week, and had a chance to talk to a lot of different SSIS users. One of the big topics seemed to be Slowly Changing Dimensions – I had a number of people ask for various improvements to the current Slowly Changing Dimension
Posted by mmasson | 1 Comments
Thursday, November 12, 2009 11:29 AM

Something new for SSIS in SQL Server 2008 R2 November CTP

Ok, so it turns my previous post about R2 wasn’t entirely correct. SSIS does have one new feature which appears in the latest SQL Server 2008 R2 CTP . If you open up the ADO.NET Destination UI, you’ll notice a new “Use Bulk Insert when Possible” check
Posted by mmasson | 0 Comments
Filed under: , , ,
Thursday, October 29, 2009 12:01 PM

2009 PASS Summit next week

I’m really looking forward to attending PASS next week! I’ll be presenting two separate talks this time around: Maximize Your SSIS Investment with Tuning Tricks and Tips Session Details Maximize the performance of your packages with this set of best practices
Posted by mmasson | 0 Comments
Filed under:
Friday, August 14, 2009 3:20 PM

No new features in for Integration Services in SQL Server 2008 R2

Update 2009-11-12 : One minor feature change announced . Have you been holding your breath waiting for Microsoft to announce the new SSIS features for SQL Server 2008 R2 ? The answer is pretty simple – nothing new is being added for SSIS in R2. There
Posted by mmasson | 5 Comments
Wednesday, August 12, 2009 8:39 AM

SQL PASS 2009

I was just looking at the sessions for the SQL PASS 2009 Summit and was happy to see so many SSIS presentations on the list! Andy Leonard Applied SSIS Design Patterns Steve Simon SQL Server Integration Services and the modern financial institution Davide
Posted by mmasson | 0 Comments
Monday, August 03, 2009 9:21 PM

Looking up SSIS HResult / COMException ErrorCode

The method I describe in my post about handling COMExceptions during package generation works if you have control over the package generation code, but sometimes you’ll be using third party libraries, or debugging after the fact. Note, the error codes,
Posted by mmasson | 0 Comments
Filed under:
Monday, August 03, 2009 8:27 PM

Debugging a COMException during package generation

You’ll occasionally receive a COMException when you’re programmatically generating SSIS package – typically when dealing with Data Flow components. These COM Exceptions will provide you with an HRESULT (ErrorCode), and no additional information. System.Runtime.InteropServices.COMException
Posted by mmasson | 0 Comments
Filed under:
Monday, June 29, 2009 10:09 AM

Speaking for the Vancouver BI PASS Chapter

I’ll be presenting for the Vancouver BI PASS Chapter next Friday, July 10th, at the Microsoft Canada offices. I really enjoyed meeting the Pacific Northwest SQL Server User Group a couple of weeks ago, and I’m looking forward to sharing SSIS with my fellow
Posted by mmasson | 0 Comments
Filed under:
Wednesday, June 17, 2009 10:18 AM

Scripts and assembly caching in 2005

A recent discussion with MVP Andy Leonard about a new property which showed up on the Script Task in SQL Server 2005 SP3 reminded me that I’ve been meaning to blog about how the script task and script component cache their precompiled code at runtime.
Posted by mmasson | 2 Comments
Filed under:
Tuesday, June 02, 2009 8:41 AM

Speaking at the PNW SSUG

I’ll be speaking at the Pacific Northwest SQL Server User Group meeting next Wednesday, June 10th. I’ll be giving an updated version of the Avoiding Common Pitfalls in SSIS talk I gave at TechEd a couple of weeks ago. It will be my first time attending
Posted by mmasson | 0 Comments
Filed under:
Tuesday, May 26, 2009 9:24 AM

More tutorial videos on Jumpstart TV

A while ago I posted about the great SSIS tutorials available on Jumpstart TV , and it’s been one of my most read blog posts so far. In the two years or so since I originally posted it, they’ve been busy adding new content for SSIS , as well as other
Posted by mmasson | 1 Comments
Tuesday, May 26, 2009 9:01 AM

Tutorial: SSIS Performance Videos

This post is coming a little late (these have already been announced here and here ), but incase you haven’t seen these before, I wanted to bring attention to four new performance related created by the SQLCAT and SSIS teams. They mostly focus on larger
Posted by mmasson | 1 Comments
Wednesday, May 20, 2009 2:42 PM

Avoiding Common Pitfalls in SSIS

I’ve uploaded the slides for the Chalk Talk I gave at TechEd last week. I always appreciate feedback (good or bad), and I’ve gotten some great comments so far. If you attended the session (or just like the slides), feel free to comment below.
Posted by mmasson | 2 Comments
Filed under:
Saturday, May 02, 2009 5:53 PM

Samples for the CDC & Merge demo

I’ve put together the samples I used in the Incremental Data Warehousing talk I did at the SSWUG.Org Virtual Conference. You can download them from my sky drive, here: The zip has a readme.txt file that should explain how to setup and run the samples.
Posted by mmasson | 0 Comments
Wednesday, April 08, 2009 8:48 AM

Sample videos posted for the SSWUG.ORG Virtual Conference

They’ve posted 10 minute previews for some of the talks at the upcoming SSWUG.ORG Virtual Conference . Here are some of the SSIS related topics: Matt Masson - Incremental Data Warehouse Loads with Merge & CDC John Welch -  Doing More (ETL) With
Posted by mmasson | 0 Comments
More Posts Next page »
 
Page view tracker