Timeout in SSIS
- yello
- Topic Author
- 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?
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?
Please Log in or Create an account to join the conversation.
- yello
- Topic Author
- 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.

Please Log in or Create an account to join the conversation.
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
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- Timeout in SSIS