Re: ActiveX task hangs in DTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

It is strange it does not complete for you though




"Sam123" <thesnakepath@xxxxxxxxx> wrote in message news:thesnakepath@xxxxxxxxx:

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:
> 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@xxxxxxxxx> wrote in message
news:1115665940.667260.151550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > 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
> >


.

Relevant Pages