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

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)
  • New to Python: my impression v. Perl/Ruby
    ... I've been a long-time Perl programmer, though I've not used a boatload ... I decided to look into Python and Ruby. ... together very quickly using Python's POP3 package. ...
    (comp.lang.python)
  • Re: Reassessing the state of Lisp
    ... install two other python packages before being able to use it. ... And yesterday I wanted to use dvdrip (a perl package) and I couldn't ...
    (comp.lang.lisp)
  • Re: Using Python in ActiveX task - works when run as separate step
    ... The way I defined my task was by defining a Mainfunction in Python and putting all of my code in there. ... Though it is possible to use different script engine such as perl, Python in ActiveX task, it is not official support. ... When I step through the package running each step, ... | saying that the function is starting to execute. ...
    (microsoft.public.sqlserver.dts)
  • Re: Python versus Perl ?
    ... Reinhold Birkenfeld wrote: ... >> I've read some posts on Perl versus Python and studied a bit of my ... but have been using Perl because it is great for pattern ... > when you don't find a needed package there, ...
    (comp.lang.python)