MSDN publishes first 2 articles by Integration Services product vendors

MSDN/TechNet has just published 2 new articles by third-party vendors of commercial products that work with, or complement, SQL Server Integration Services.

In Extending Integration Services with the Script Task and Script Task Plus, Ivan Peev of CozyRoc talks about the built-in Script task, then discusses the additional features provided by Script Task Plus, a component that's included in the SSIS+ library from CozyRoc. For example, Script Task Plus lets you reuse the same script easily in more than one location, and parameterize your scripts simply by defining public properties in your code. Another commonly-requested feature that's included in the SSIS+ product is a Secure FTP task.

In Managing Data Quality with Integration Services and Data Quality Manager, Andrew Wong and Dean Sutcliffe from Australia demonstrate some techniques for data profiling and cleansing in SQL Server, then go on to explain how they've made parsing more intelligent, and wrapped that functionality in an easy-to-use user interface, in their commercial product. Their Data Quality Manager product includes a data quality scorecard that conveniently summarizes profile results in both tabular and graphical format.

If you are the vendor, or friend of a vendor, of a product that works with, or complements, SQL Server Integration Services, please don't hesitate to contact me about the guidelines for submitting an article along these lines for publication. We don't currently have a page on the Microsoft Web sites that features SSIS vendors. Compiling a list of vendors and products, if only an unofficial list, is one of those things that I hope to do someday "when I have the time".