Hi......

For some reason everytime I run a DTS package with an ActiveX Script
Task it hangs. So I tried to create a test package with only an ActiveX
Script Task and it still hangs. The code in the task does only 2 things
(for testing), reads a variable and assigns a number to it. I tried
rebooting and it didnt help.
The only way to stop the package once it hangs is to
select ctrl + alt + del and to kill the task. I've let the package run
for over an hour and it was still hanging.


any ideas???

thank you
sam

Probably throwing an exception.

--
Jim Vierra

"Sam123" <thesnakepath (AT) yahoo (DOT) com> wrote

It hangs when you manually execute it?

Can we see the script?

Which version of SQL Server and what service pack?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Sam123" <thesnakepath (AT) yahoo (DOT) com> wrote

Hi......

yes, it hangs when its executed manually and if scheduled.

Version is SQl server 2000
service pack: 3

the script is simple, see below:

Function Main()

dim x
dim y

x=5
y=8

Main = DTSTaskExecResult_Success

End Function


Allan Mitchell wrote:

I am running SQL 2000 SP4 and this runs fine there.

It is strange it does not complete for you though




"Sam123" <thesnakepath (AT) yahoo (DOT) com> wrote

add a ...
MsgBox "Package Done!"

statement prior to your "Main=...." line.
enable logging to a server located .txt file.

Make sure you do not have a Workflow script on the Step, this gets executed
prior to the Task!

reattempt to execute the package from the Designer GUI.
(make certain that the step is defined to actually execute)

This should give you a better clue as to if the task is executing properly.

-Mike Gercevich

--
Message posted via http://www.sqlmonster.com