rajib has asked for the wisdom of the Perl Monks concerning the following question:

Hi, Everyone,

I am looking into building a SSIS package that will utilize perl bots. Has anybody done anything similar to do this? I'd like to hear some pitfalls so that I can avoid them.

Please point me to few articles that is related to this or some article that covers perl bots programming across any level from beginner to advanced. Thanks a lot for responding to my earlier requests.

Update:
Here is an article that talks about PerlDTS. I got it yesterday from SqlServerCentral.com http://www.sqlservercentral.com/articles/Perl/65025/

Rajib

Replies are listed 'Best First'.
Re: SSIS and Perl bots
by Tanktalus (Canon) on Dec 18, 2008 at 22:15 UTC

    Seeing as how you've managed to get no responses thus far, I'll continue the trend. Perhaps you'd like to expand on what "SSIS" is, how you think a "perl bot" will be of any use (perhaps it'll be obvious once you describe SSIS, but maybe not), or any other details that might help the reader of your query understand what you're talking about.

    A quick google shows one potential meaning of SSIS as SQL Server Integration Services - is this what you're refering to? If so, how do you envision a perl bot being of use? As a hosting environment? In that role, it merely looks like standard coding: looking for events, and responding to them. But I'm not entirely sure...

      Thanks for your reply. You're correct about SSIS. I used that tool for Business Intelligence or datawarehousing projects. I was looking tie that tool and use bots in perl to pull down certain publicly available data from websites of interest. Later I want to do some data mining on them. I can achieve something similar in a C# .NET desktop application... I just wanted to compare the time cost and feature benefits w/ perl bots. Have I clarified myself? :)