Tuesday, December 23, 2008

Perl meets DTS

If you work with Microsoft SQL Server and maintain DTS Packages you may find the PerlDTS Package worth investigating.

Alceu Rodrigues de Freitas Junior writes "DTS offers several features to help managing ETL processes, including process automation, scheduling and notification."

Alceu's motivation was to improve his productivity because he was working with "hundreds of DTS packages to implement batch integration with Oracle Siebel CRM."

Alceu has implemented many of the DTS API classes in his PerlDTS package; however he adds "there is still a lot of other ones to implement".

If you are working with SQL Server and DTS you may want to leverage PerlDTS in your work.

http://www.sqlservercentral.com/articles/Perl/65025/

No comments: