I currently have a DTS package that used to work on our server. The ActiveX
task hangs on one server, runs on a different server and will execute
locally. Is there something I need to be looking for on the server where the
hanging occurs. If I reboot the server, it will work for a short time and
then start hanging again. I have other applications running on this server,
so rebooting daily is not an option. Any suggestions?

Sounds as though maybe something is getting stuck. What does the AX task
do? Does the same thing work consistently outside of DTS (vbScript)?


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Gregory C. Quinn, Jr." <gquinn (AT) triad (DOT) rr.com> wrote

It happens with any ActiveX task in DTS on this particular server. The main
part is assigning values to Global Variables and reading values from Global
Variables. Running this same DTS Package on my desktop using Enterprise
Manager or running on another server completes successfully. I did not know
if there was something in particular I could check on this particular server
to identify the problem. When I reboot the server, it works ok for a short
while and then stops working again. Again, this only happens on this
particular server. It is SQL Server 2000 Enterprise with SP3. Any
Suggestions?

Thanks,

Greg

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

None really other than if it deteriorates over time then maybe something is
being eaten up (resources). Is it consistent?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Gregory C. Quinn, Jr." <gquinn (AT) triad (DOT) rr.com> wrote