Timeout in SSIS

More
5 years 9 months ago #11173 by yello
yello created the topic: Timeout in SSIS
I am using a EMC Greenplum with MS-SSIS 2008 as ETL-Tool. With this tool i am loading MS SQL, Oracle, MySQL and now EMC Greenplum.

With EMC Greenplum there is one Problem:
The Query in the SSIS SQL-Task failed with "timeout" after 45 seconds.
In PG Admin III the query resutls in 45 seconds. i ve set the query timeout in ssis to 600 seconds, but it didnt take effect (Picture).

What should i do?
Attachments:

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #11174 by yello
yello replied the topic: Re: Timeout in SSIS
Even editing the "connect timeout" from 0 to 600 didn't take effect. :(
Attachments:

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #11175 by Moderator
Moderator replied the topic: Re: Timeout in SSIS
Please add COMMAND_TIMEOUT=900 to the Extended Properties (All tab). The timeout is in seconds. Zero means infinite.

Please Log in or Create an account to join the conversation.

Time to create page: 0.086 seconds
Powered by Kunena Forum