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

Hello Peter,

The whole DTS package also works properly for perl.

I downloaded ActivePython, installed it and test the function you provided,
I could execute the task but it stoped to respond when execute the whole
package.

Also, I found AutoGen does not work for Python.

It seems Python cannot work with DTS in SQL server.

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
    ... I just used some simple script to test: ... I installed ActivePerl on my test machine, create a new DTS package, and a ... new ActiveX script task. ... |>>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • 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)
  • 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)