Re: ActiveX task hangs in DTS
- From: "Sam123" <thesnakepath@xxxxxxxxx>
- Date: 13 May 2005 12:20:29 -0700
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
> >
.
- Follow-Ups:
- Re: ActiveX task hangs in DTS
- From: Mike Gercevich via SQLMonster.com
- Re: ActiveX task hangs in DTS
- From: Allan Mitchell
- Re: ActiveX task hangs in DTS
- References:
- ActiveX task hangs in DTS
- From: Sam123
- Re: ActiveX task hangs in DTS
- From: Allan Mitchell
- ActiveX task hangs in DTS
- Prev by Date: Re: DTS Package Import
- Next by Date: Re: Need Example exec proc from VBScript ActiveX DTS.
- Previous by thread: Re: ActiveX task hangs in DTS
- Next by thread: Re: ActiveX task hangs in DTS
- Index(es):
Relevant Pages
|
