Win32 MsgBox doesn't appear under DTS

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

I'm using ActiveState's PerlScript under MS SQL Server 2000, as an ActiveX scripting language in DTS (Data Transfer Services) packages. For quick popup messages, I wanted to use the MsgBox function that's part of Win32::Shell. (Actually I couldn't find Win32::Shell on CPAN -- I found it on AS's PPM repository.)

To my surprise, the message box doesn't pop up when the script executes as part of a DTS package. It does pop up when the script's run out of a command line. If I change the scripting language to VBScript (ow, ow, stop, I won't say it anymore) the MsgBox pops up OK. It's only the combination of DTS and PerlScript that fails (which is where I need it, of course).

There's very little documentation in Win32::Shell. I've searched the ActiveState web site and also the Monastery, and haven't found anything. So, fellow Monks, I turn to you: does anyone know what's wrong? Or better still, how to fix this?

TIA

Comment on Win32 MsgBox doesn't appear under DTS Select or Download Code

Replies are listed 'Best First'.
Re: Win32 MsgBox doesn't appear under DTS by chinman (Monk) on Sep 25, 2002 at 22:29 UTC
VSarkiss It sounds like you just need Win32::MsgBox which is part of the standard AS distribution. Check the ActivePerl docs under the Win32 section or here's the POD on CPAN http://search.cpan.org/author/JHI/perl-5.8.0/lib/Win32.pod Regards, chinman	[reply]
Re: Re: Win32 MsgBox doesn't appear under DTS by VSarkiss (Monsignor) on Sep 25, 2002 at 22:50 UTC
Great, that works! I don't know where I got the impression I had to use `Win32::Shell::MsgBox` rather than just `Win32::MsgBox`. Once again, the monks come through. Thanks a lot!	[reply] [d/l] [select]