Timeout in SSIS

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Timeout in SSIS

Postby yello » Wed Jul 30, 2014 1:43 am

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
Picture.jpg
SSIS 2008
Picture.jpg (136.3 KiB) Viewed 597 times
yello
 
Posts: 7
Joined: Wed Jul 09, 2014 1:20 am

Re: Timeout in SSIS

Postby yello » Wed Jul 30, 2014 1:52 am

Even editing the "connect timeout" from 0 to 600 didn't take effect. :(
Attachments
Picture2.jpg
Picture2.jpg (143.66 KiB) Viewed 596 times
yello
 
Posts: 7
Joined: Wed Jul 09, 2014 1:20 am

Re: Timeout in SSIS

Postby Moderator » Wed Jul 30, 2014 11:27 am

Please add COMMAND_TIMEOUT=900 to the Extended Properties (All tab). The timeout is in seconds. Zero means infinite.
User avatar
Moderator
Site Admin
 
Posts: 302
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest

cron