Timeout in SSIS

  • yello
  • Topic Author
  • Visitor
  • Visitor
8 years 6 months ago #11173 by yello
Timeout in SSIS was created by yello
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.

  • yello
  • Topic Author
  • Visitor
  • Visitor
8 years 6 months ago #11174 by yello
Replied by yello on 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
8 years 6 months ago #11175 by Moderator
Replied by Moderator on 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.062 seconds
Powered by Kunena Forum