Expression Adorners

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 session at TechEd, the functionality has been further enhanced since CTP3, and…


SSIS T-SQL API Overview

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 objects in the new Integration Services catalog (SSISDB), as well as…


Using the PipelineComponentTime event

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 event is a very useful custom log entry used for…


Package Format Changes in SQL Server Denali

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 data flows (specifically, the way we persist lineage IDs) also…


Column Mapping Improvements in Denali

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 destination to source). Take the following example (which I walked through in my Denali…


Troubleshooting SSIS Package Performance Issues

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 in Denali, see Jamie Thomson’s post about report authoring. When an…


The Import Project Wizard

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 IS Projects that are saved on the disc in the form of .ispac files….


Debugging Configuration Issues on the Server Using Reports and T-SQL views

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 of the execution failure. In the following example, the execution failed because the server name was incorrect. This…


The Project and Parameter Object Model

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 the new concepts we introduced including project and parameter. Project Object Model…