May
10
2008

Adding the error column name to an error output

It’s a common frustration with Error Outputs in Integration Services that you get numeric identifiers for the error that occurred and the column that caused it, but you don’t automatically get the description of the error or the name of the column. It’s easy to add the description of the error with 1 line of code in a Script component, as described in this BOL topic: Enhancing an Error Output with the Script Component. It’s not so easy to add the name of the column. (Note: In some... [More]
May
3
2008

Using connection managers in managed code

SQL Server 2008 Books Online will have a long-needed topic that lists the return values from the AcquireConnection API method for each in-the-box connection manager. The developer needs to be able to cast the return value to the proper type, but these types are somewhat...unpredictable. While the Flat File Connection Manager returns a string, the ADO.NET Connection Manager with SqlClient returns an open SqlConnection. I distracted myself at work one day by adding and configuring a connection mana... [More]
May
3
2008

SSIS features by edition in SQL Server 2008 "Katmai"

There are no big surprises in the breakdown of Integration Services features by edition for SQL Server 2008 "Katmai". A couple of notes... The Import and Export Wizard is now included with SQL Server Express. The new Data Profiling Task and Data Profiling Viewer are included in Standard edition. The new connectivity components for SAP BW, Oracle, and Teradata (which will be released as Web downloads after RTM on the Feature Pack page) will work only with Enterprise/Developer/Evaluation editi... [More]
May
1
2008

Expressionable data flow component properties in Katmai

To supplement the current version of the list that's here in BOL, here are some additions or corrections to the list of custom properties of data flow components whose values can be set by using an expression in SQL Server 2008 "Katmai": ADO Source (formerly DataReader Source) SqlCommand TableOrViewName ADO Destination BatchSize CommandTimeout TableOrViewName Lookup Transformation SqlCommand (the SELECT statement that you optionally enter on the Connection page) SqlCom... [More]
Apr
28
2008

DTS support in SQL Server 2008 "Katmai"

[REVISED WITH ADDITIONAL INFORMATION SAT 5/24/08, MON 5/27/08, MON 10/13/08] It may seem ironic to start a new blog by talking about old stuff. But we all loved DTS in our youth, and it’s been a popular subject in my Inbox lately. Run-time support for DTS The good news for DTS users is that DTS receives the same degree of support in SQL Server 2008 “Katmai” as in SQL Server 2005 “Yukon”. The bad news is that it’s less convenient (in Katmai) to install that support. Run-t... [More]
Apr
28
2008

Welcome!

I enjoy working on the official documentation for SQL Server Integration Services at Microsoft, and striving to make it better. This Web site and blog are an entirely unofficial extension of my daily work and of my enthusiasm for IS. Sometimes there are things that you deserve to know before the next release of Books Online. Or tips and gotchas that will never earn a page in BOL or a Knowledge Base article. Or code that I wrote that doesn’t include robust error-handling. Thus the new blog. I hope to b... [More]