ActiveX Script Task TimeOut Error.

Question

ActiveX Script Task TimeOut Error.

Robert W Marda

SSChampion

Points: 13413
More actions
December 11, 2002 at 7:48 pm

#105417

Why do I get a time out expired error after my ActiveX Script Task runs for about 30 seconds? All it does is create indexes on some tables. Is there a way for me to increase the time out time? I've been looking for a way but haven't found it yet.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

don1941 SSCarpal Tunnel Points: 4183 More actions · Answer 1

Why are you doing this in DTS?

If your tables are large ,you might be timing out just becuase it takes longer to do than the default script timeout value.

I would look for another way to do this if I were you.

Robert W Marda SSChampion Points: 13413 More actions · Answer 2

This is part of a complex DTS package and is needed. I recently converted it from an Execute SQL Task to the ActiveX Script Task to take advantage of global variables.

You are right, the tables in this task are large. At worst case I can convert it back to an Execute SQL Task.

The reason for the conversion is because the task doesn't always get executed and I wanted to avoid the failed log entry that occurs in the error log when you mark a task as completed.

I want to increase the default script timeout value. Is this possible? If so then how can I do it?

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.

Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems

jfb SSCrazy Points: 2469 More actions · Answer 3

Inside the pkg--> mouse right click -->Disconnected Edit-->Here is all the properties for the connection and for the steps, inside each connection you can find the time out propertie.

Johnny...

Robert W Marda SSChampion Points: 13413 More actions · Answer 4

I never knew about that. This looks to be promising for other things, however I don't see timeout options for an ActiveX Script task. I see them for connections, unfortunately the connections used by the ActiveX Script are created when that task runs. I have discovered some thing else that will work for us so that I won't need to have this task be an ActiveX Script task. I discovered that I can use an ActiveX Script to check a global variable and then based on the value decide if the task will be executed or not. So, I converted the task bact to an Execute SQL Task and avoided the problem.