May 2008 - Douglas Laudenschlager

DTS application properties

There's a dialog box of DTS application-wide settings that disappeared from SQL Server 2005 and 2008. It used to live on the context (right-click) menu of the DTS node in SQL Server 2000 Enterprise Manager. One day in a moment of spare time I set...

Published Mon, May 26 2008 1:41 PM by dougbert

Filed under: DTS, source code

Text Mining with Term Lookup and Term Extraction

(Note: The Term Extraction and Term Lookup transformations are available in Integration Services only in the Enterprise edition of Microsoft SQL Server 2005 and 2008, and in the Developer and Evaluation editions which are variants of Enterprise.) The...

Published Sat, May 24 2008 9:12 by dougbert

Filed under: data mining, text mining

Adding a VSTA Script task programmatically (revised)

[UPDATED WITH A BETTER CODE SAMPLE FOR THE 2ND SCENARIO TUE 6/10/08] The move in SQL Server 2008 Integration Services from VSA to VSTA for scripting doesn't just give us C# and a better IDE and Add Reference dialog. It has also made programmatic manipulation...

Published Sat, May 24 2008 8:55 by dougbert

Filed under: 2008, Script task, programming

9 Integration Services blogs for the price of 1

Download this opml file and you can add the RSS feeds for the Integration Services product team's blog (Matt Masson) and 8 more blogs by Integration Services MVPs all at once. For those still getting up to speed with RSS feeds... Here's where...

Published Sat, May 24 2008 8:29 by dougbert

Filed under: mvp, blogs

Expanded "Feature Selection" page in the SQL Server 2008 Setup Wizard

Just when I thought that I was finally finished with our Setup-related topics! Those wily Setup folks added items to the "Feature Selection" page in the SQL Server 2008 Setup Wizard since I last installed a Katmai build. A couple items need...

Published Thu, May 15 2008 11:18 by dougbert

Filed under: setup, 2008

The mystery of MULTIFILE

So the other day I was wondering what the heck a Multiple Files connection manager was good for. I read this statement in BOL by a respected predecessor... "A Multiple Files connection manager enables a package to reference existing files and folders...

Published Wed, May 14 2008 11:15 by dougbert

Filed under: connection manager, multifile

Dynamic package generation, and Codeplex

After reading the recently-posted "Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services" article on MSDN, I hunted all over the page for the link to some sort of sample, and there wasn't one! Personally...

Published Tue, May 13 2008 3:18 PM by dougbert

Filed under: metadata-driven ETL, Codeplex

My Variable doesn't like my Object any more - FIXED!

THIS LIMITATION HAS BEEN FIXED AND REMOVED FOR SQL SERVER 2008 RTM. Object of any type can now be passed through package variables of type Object, and consumed within Script task code. No, wait. Maybe it's "My Object doesn't like my Variable...

Published Tue, May 13 2008 3:11 PM by dougbert

Filed under: 2008, Script task, known issue

Sticky note: Authentication in protocol connection managers

Whenever I read user comments about the inconsistent support for authentication methods in our 3 protocol connection managers, I have to go back again and figure out which ones support which methods. So the chart finally became one more sticky note on...

Published Sat, May 10 2008 10:02 by dougbert

Filed under: connection manager, authentication, http, smtp, ftp

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...

Published Sat, May 10 2008 9:45 by dougbert

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...

Published Sat, May 03 2008 9:39 by dougbert

Filed under: connection manager

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...

Published Sat, May 03 2008 9:19 by dougbert

Filed under: 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"...

Published Thu, May 01 2008 10:20 by dougbert

Filed under: 2008, expressions