New and Improved Connectivity Wiki

We’ll soon be taking down the old connectivity wiki, and have moved all of the content to the new Technet Wiki Pages. You can find a full list of SSIS wiki pages here, or you can click through to the connectivity related pages linked below: SSIS 64 Bit Story SSIS Connectivity White Paper SSIS Connection…


EzAPI – Update

I’ve just updated the Codeplex version of EzAPI – an alternative SSIS package creation API. If you missed the previous release, I definitely recommend checking it out. Updates include : Support for additional containers, tasks and components Bug fixes from the team Additional patches submitted by Codeplex users List of additional containers, tasks & components…


SQL Server Denali Resource Center

Looking for more information on SSIS functionality in SQL Server Denali? Head over to the SQL Server Denali Resource Center. There are plenty of articles and links to community blog posts, as well as 12 videos about the new functionality in SSIS. Migration and Deployment Working with Integration Services projects in Business Intelligence Development Studio…


SSIS Tips & Tricks

Steve Swartz’s SSIS Tips & Tricks session from TechEd Europe 2010 is available online. Be sure to check it out! SSIS 2008: Tips and Tricks Are you starting up a new project with SQL Server Integration Services? Do you want to speed up an existing project but don’t have the time or budget for heavy…


SQL Server Denali – What’s Coming Next in SSIS

Thanks to everyone who attended my session at SQL PASS yesterday. The recording of the session isn’t available yet, but thankfully, Steve Swartz, the Group Program Manager for the SSIS team, presented the same content about SQL Server Denali at TechEd Europe. The video is available online (for both download and streaming). What’s Coming Next…


SQL PASS Summit 2010

Will you be attending PASS this year? I’ll definitely be there, along with most of the SSIS team! I’ll be presenting a talk about the next version of SSIS, and representing SSIS in the BI Power Hour. Be sure to swing by the product pavilion and Ask the Experts area as well – it’s a…


Upcoming Product Changes

We’ve been hard at work on the next version of SQL Server, and it’s (almost) time to start sharing some of exciting new functionality we’ve introduced to SSIS. Over the new few months (starting about the time the first public CTP drops), I expect you’ll see a lot new content appearing here, technet, and other…


Speeding up Derived Column Transforms

A new technical note about splitting up transforms to increase performance has been posted on the SQLCAT site. It’s something you want to consider when you’re using synchronous transforms (like Derived Column, or Data Convert) to perform actions on a large number of columns. It seemed like black magic at first, but if you consider…


Optimizing the Slowly Changing Dimension Wizard

As a follow-up to my previous post about SCD processing in SSIS, I thought I’d go deeper into using the built-in Slowly Changing Dimension Wizard. While there are definitely more efficient ways to do SCD processing in SSIS, there are some optimizations you can apply to the components that the wizard outputs that might make…


String to Date conversion

This question recently came up on an internal SSIS mailing list: We’re converting date strings to date columns using the Derived Column transform. We’ve noticed some weird conversion behavior with older dates, like ‘0001-01-01’. It seems that year values under 30 go to the year 2000, and 30 and over go to 1900. So SSIS…