Set TimeoutSeconds to the maximum amount of time you want to permit. The default is 0, in which case Execute will not timeout.

When this time is exceeded, Execute will halt leaving incomplete results in the OutputFile or OutputString. If TimeoutSeconds is 0 (the default), no time limit will be set. After a timeout has occured, the Errors property will contain an message code dtsErTimeout.