Using Python in ActiveX task - works when run as separate step, hangs when executing package

From: Peter A. Schott <paschott@xxxxxxxxxxxxxxxx>
Date: Wed, 17 Aug 2005 11:22:20 -0500

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
.

Follow-Ups:
- RE: Using Python in ActiveX task - works when run as separate step, hangs when executing package
  - From: Peter Yang [MSFT]
- RE: Using Python in ActiveX task - works when run as separate step, hangs when executing package
  - From: Peter Yang [MSFT]

Prev by Date: Select statements output file.
Next by Date: Re: Is possible to FTP Upload with DTS instead of downloading a text f
Previous by thread: Select statements output file.
Next by thread: RE: Using Python in ActiveX task - works when run as separate step, hangs when executing package
Index(es):
- Date
- Thread

Relevant Pages

Nested packages not firing events when executed via .NET interop
... This works fine on individual packages, but when I execute a package ... void PackageEvents.OnError(string EventSource, int ErrorCode, ...
(microsoft.public.sqlserver.dts)
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: alter index (Oracle Text index) rebuild on different schema => no rights
... I put the "alter index" statement in a stored procedure and put it in ... The execution of the package has to ... Execute it dynamically as a workaround. ... REBUILD statement without proper PARAMETERS clause (which ...
(comp.databases.oracle.misc)
Not all steps in DTS package execute
... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
(microsoft.public.sqlserver.dts)
Re: DTSStepExecResult, DTSStepExecStatus, and execute package task
... It's a step error within a package and not a package error. ... do you know of a way to execute a specific function within ... Dim ErrorSource ... > The exec package task worked, it executed the child package, so is a child ...
(microsoft.public.sqlserver.dts)