May 2008 - Posts

DTS application properties
Published 26 May 8 1:41 PM | dougbert
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...
Filed under: ,
Text Mining with Term Lookup and Term Extraction
Published 24 May 8 9:12 AM | dougbert
(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...
Filed under: ,
Adding a VSTA Script task programmatically (revised)
Published 24 May 8 8:55 AM | dougbert
[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...
Filed under: , ,
9 Integration Services blogs for the price of 1
Published 24 May 8 8:29 AM | dougbert
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...
Filed under: ,
Expanded "Feature Selection" page in the SQL Server 2008 Setup Wizard
Published 15 May 8 11:18 AM | dougbert
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...
Filed under: ,
The mystery of MULTIFILE
Published 14 May 8 11:15 AM | dougbert
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...
Filed under: ,
Dynamic package generation, and Codeplex
Published 13 May 8 3:18 PM | dougbert
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...
Filed under: ,
My Variable doesn't like my Object any more - FIXED!
Published 13 May 8 3:11 PM | dougbert
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...
Filed under: , ,
Sticky note: Authentication in protocol connection managers
Published 10 May 8 10:2 AM | dougbert
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...
Filed under: , , , ,
Adding the error column name to an error output
Published 10 May 8 9:45 AM | dougbert
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...
Filed under:
Using connection managers in managed code
Published 3 May 8 9:39 AM | dougbert
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...
Filed under:
SSIS features by edition in SQL Server 2008 "Katmai"
Published 3 May 8 9:19 AM | dougbert
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...
Filed under:
Expressionable data flow component properties in Katmai
Published 1 May 8 10:20 AM | dougbert
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"...
Filed under: ,