RE: Using Python in ActiveX task - works when run as separate step

Well, I've got a bunch of other VBScript tasks running without any issues. I
was trying to use Python in this case because I know it a little better than
VBScript and it was easier to do what I needed. I will try the
auto-generation of a blank function and see if I can run just that as a whole.

The way I defined my task was by defining a Main() function in Python and
putting all of my code in there. Do I need to call the function as well or
will DTS call the main() function? Do I just need to put my code in there
without a function? Can you give me a sample of how you got your ActivePerl
code to work? That may give me some pointers.

Thanks for your help.

-Pete


"Peter Yang [MSFT]" wrote:

> Hello Pete,
>
> Though it is possible to use different script engine such as perl, Python
> in ActiveX task, it is not official support.
>
> It is suggest that you use a simple test script ( I use VB script as
> sample) to make sure if Python can work under this stiaution
>
> Function Main()
>
> DTSGlobalVariables( "Test" ) = "Test"
>
> msgbox DTSGlobalVariables("Test")
>
> Main = DTSTaskExecResult_Success
>
> End Function
>
> You could execute the step in DTS package window.
>
> I ever installed Perl and it works OK. If above step fail, please try to
> click "Auto Gen" to generate default (blank) function to test.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> | From: Peter A. Schott <paschott@xxxxxxxxxxxxxxxx>
> | Subject: Using Python in ActiveX task - works when run as separate step,
> hangs when executing package
> | Date: Wed, 17 Aug 2005 11:22:20 -0500
> | Message-ID: <sgo6g1lkvd7ti0cndf53jegli71vevptdo@xxxxxxx>
> | X-Newsreader: Forte Agent 3.0/32.763
> | MIME-Version: 1.0
> | Content-Type: text/plain; charset=us-ascii
> | Content-Transfer-Encoding: 7bit
> | Newsgroups: microsoft.public.sqlserver.dts
> | NNTP-Posting-Host: 216.178.160.231
> | Lines: 1
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:14088
> | X-Tomcat-NG: microsoft.public.sqlserver.dts
> |
> | Trying to use Python 2.4.1 with the Win32 extensions (build 204) inside
> of an
> | ActiveX task. When I step through the package running each step, the
> package
> | runs fine, even to the point of running the "message box" to see where
> the code
> | is stopping.
> |
> | When I try to execute the package as a whole, it goes through all
> preceeding
> | steps, but stops at the Python task without showing even the first
> message box
> | saying that the function is starting to execute.
> |
> | Looking at the logs, I have NULLs for stepexecstatus, stepexecresult,
> endtime,
> | elapsedtime, errorcode, errordescription, and progresscount in the
> sysdtssteplog
> | table.
> |
> | I'm running under the same users in each case as far as I can tell.
> |
> | If anyone has encountered something similar with other languages (Perl,
> PHP,
> | etc) and has fixed it, please let me know what you did.
> |
> | If anyone has any ideas on how to get some detailed errors on why it is
> hanging
> | here, please let me know and I'll post the results.
> |
> | Thanks.
> |
> | -Pete Schott
> |
>
>
.

Relevant Pages

  • Re: Using Python in ActiveX task - works when run as separate step
    ... when executing the package. ... Peter Yang, if you can detail some of what you did to get Perl working, I'd ... >> was trying to use Python in this case because I know it a little better than ... >>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • RE: Using Python in ActiveX task - works when run as separate step, hangs when executing package
    ... Though it is possible to use different script engine such as perl, Python ... in ActiveX task, ... You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • Re: Finding installed package files
    ... for making installation information more easily accessible? ... >> somewhere where more information about the key parts of the package ... >> As an example I installed the latest Python on Fedora 3. ... what one would expect is a form of help documentation much more integrated ...
    (alt.os.linux.redhat)
  • Re: problem with import / namespace
    ... Python works as expected and documented, but apparently you do not know how to import 1/tmp2.py from 2/tmp1.py. ... are creating a package with modules, then you have to define the package's name with its directory. ... Since identifiers cannot begin with digits in Python, you need to use an identifier-like name for your subdirs. ...
    (comp.lang.python)
  • stdeb - Python to Debian source package conversion utility
    ... I would like to announce the initial public release of stdeb, ... stdeb - Python to Debian source package conversion utility ... produces a Debian source package of a Python package. ...
    (comp.lang.python.announce)