Jun
8
2008

New product: EBCDIC Source component from Amino Software

Today Ben Harrell of Amino Software announced their new custom Source component, code-named "Lysine", for importing mainframe EBCDIC data into the data flow of an Integration Services package. The component also includes an EBCDIC connection manager. After Integration Services 2005 hit the streets, it wasn't long before we began seeing questions about EBCDIC imports on both the MSDN forum, and the internal SSIS discussion list a Microsoft. And there were very few satisfactory answer... [More]
May
26
2008

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 about to re-create it for use on a SQL Server 2005 or later computer with DTS support installed. Here's the VB.NET source code project. I described this in Books Online in Setting DTS Application Properties. Mine's on the right, the original... [More]
May
24
2008

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 Term Extraction and Term Lookup transformations in Integration Services were developed for SQL Server 2005 by Microsoft Research in China. They are unchanged in SQL Server 2008. I'm fascinated by data mining and text mining, but haven't had much time t... [More]
May
24
2008

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 of the Script task easier and more supportable. This week I got some sample code from Evgeny Koblov, one of our SSIS testers recently hired from Russia. His English is remarkably good...and makes me ashamed that I'm still confused by the Cyrillic a... [More]
May
24
2008

9 Integration Services blogs for the price of 1

Download this opml file [OUTDATED FILE REMOVED MARCH 2012] 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 you import an OPML file in Internet Explorer... And here's where you import an OPML file in Outlook... -Doug  
May
15
2008

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 our attention: Client Tools Backward Compatibilty does not install the DTS runtime support. (Please see this post.) Client Tools SDK lays down on disk the managed assemblies needed for Integration Services programming. Otherwise, these assemblies are installed only in th... [More]
May
14
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 or to create files and folders at run time. The tasks and data flow components in Microsoft SQL Server Integration Services that can use information in files perform their work by referencing a Multiple Files connection manager that is included ... [More]
May
13
2008

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, I'd rather have someone give me a push in the right direction with some sample code after describing such an elaborate architecture. It's not a weekend afternoon project, after all. Turns out the real thing is an internal Microsoft tool (&quo... [More]
May
13
2008

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." Anyway, we just had to remove one of the Integration Services package samples ("SmoTablesDBCC") for Katmai because of this issue that affects the Script task. There are many Types that you will no longer be able to pass into a Script task by way of a package Vari... [More]
May
10
2008

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 my wall:   Anonymous Basic Integrated(Windows) FTP Yes Yes No HTTP Yes Yes No SMTP Yes No Yes