In order to run SSIS packages, I recently installed the following
components of SQL Server 2005 September CTP on my SQL Server 2000 box
(prerequisites: Windows 2003 SP1, .net framework 2.0, Microsoft SQL
Native Client, Microsoft SQL Server 2005 CTP Setup Support Files)
(Programs: Notification Services, Integration Services, and Client
Components) (i.e., I did not install Database Services or Analysis
Services). Since that installation, scheduled jobs which contain
ActiveX scripts are hanging on execution (i.e., do not work and
continue in EXECUTING state with DTSRUN.exe processes). It does look
like this is only affecting jobs with ActiveX tasks, so it looks very
much like the problem outlined in
http://groups.google.com/group/micro...start=1&num=3&
and http://support.microsoft.com/?kbid=318819; however, the fix of
selecting EXECUTE ON MAIN THREAD on the ActiveX tasks has not resolved
the problem for me.

Other hopefully helpful notes:
(1) I am able to run the DTS from the DTS designer successfully.
(2) My environment is Windows 2003 SP1 (also just installed SP1) and
Microsoft SQL Server 2000 Standard - 8.00.818 (Build 3790: Service Pack
1).
(3) I don't know if it's related, but the SQL Error Log also just
started issuing (Error: 1073759806, Severity: 1, State: 0)

Thanks in advance,
Jeff