August, 2011

A quick post today about SQL Server Denali. BIDS now uses a special icon marker (called an Adorner) to indicate package objects that have expressions set on them. In CTP3, these adorners appear on Connection Managers and Variables. As I mentioned in my...

I’ll be presenting SSIS topics for two Canadian user groups next month - the Communauté .NET Montréal on September 7th, and the OttawaSQL.NET group on September 15th. Both sessions have the same abstract, but will have different content as I will be giving...

Today’s post is from Carla Sabotta, lead writer for the Integration Services team. It covers the stored procedures and Views that make up the API for the new SSIS Catalog in SQL Server Denali. You can use Transact-SQL views and stored procedures to manage...

Today’s post is from Wee Hyong Tok – a Program Manager on the SSIS team based in Shanghai. It covers the PipelineComponentTime event, which was introduced in SQL Server 2008, and talks about how the event can be used in SQL Server Denali. The PipelineComponentTime...

We made some significant changes to the .dtsx file package format in SQL Server Denali. The goal of these changes was to make the SSIS package format easier to read, and easier to diff when working with source control systems. Some of the changes around...

Today’s post is from Rujin Cao – a developer on the SSIS team based in Shanghai. This article talks about the .NET assembly binding we include in our .exes by default, which makes migrating custom SSIS code to Denali a lot easier. Note that while this...

We made a number of changes in Denali around the use of lineage IDs, and auto-mapping of metadata. Collectively, these improvements were internally called “Flexible Order of Authoring” (because the idea was that you could build a package backwards – from...

Today’s post is from Wee Hyong Tok, a Program Manager with the SSIS team based in Shanghai. It provides some tips on using T-SQL to analyze performance issues for packages running on the new SSIS Catalog. For more information about the new logging functionality...

Today’s post is from Ranjeeta Nanda, a Software Development Engineer in Test on the SSIS team. This post describes the new “Integration Services Import Project Wizard” project type in BIDS in Denali. ----------------- By now, you know that SSIS now has...

Today’s post is from Da Lin – a tester on the SQL Server Integration Services team. ------------------------------------- With the built-in reports and TSQL views , Integration Services in SQL Server “Denali” allows you easily identify the root cause...

Back to the Denali theme - today’s post is from Xiaochen Wu, a tester on the SSIS team based in Shanghai. ------------------- In SSIS, we can manipulate packages programmatically with the SSIS object model. In Denali, we extended the object model to support...

Today’s post isn’t specifically about SQL Server Denali, but still a worthy addition to the 30 Days of SSIS series. The Balanced Data Distributor is a new data flow component created by the SQLCAT team , and available for download from Microsoft.com ...

The (preliminary) SQLBits 9 conference agenda has been posted ! I’ll be presenting an SSIS session entitled “What’s New in SQL Server Denali” which covers most of what we showed at TechEd , as well as some of the integration with the other EIM products...

Today’s post is from Carla Sabotta - lead writer for the SQL Server Integration Services team. ------ In SQL Server “Denali”, you can undo and redo up to 20 actions in the SSIS Designer. For a package, undo /redo is available in the Control Flow, Data...

After a short hiatus, the 30 Days of SSIS series is back! Today’s special guest post is from Jamie Thomson . -------------------------------------------- SSIS Catalog Log Tables As you may already have gleaned from earlier posts in the 30daysofSSIS series...