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

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.

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