1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. Timeout in SSIS

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.

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. Timeout in SSIS
Time to create page: 0.062 seconds
Powered by Kunena Forum