sql server dts: SSIS Timeout error -- sql server dts

SSIS Timeout error

mystical potato
7/31/2006 12:08:02 PM

sql server dts:

I am executing a Data Reader task connecting to a 2000 sql server using a
..net/sqlclient data provider. The task fails after 30 seconds and returns
the following error:

Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding.

I increased the timeout on the connection object to 3000 seconds but it did
not have an impact. The package still errors out after 30 seconds. I'm
trying to execute as sql statement that takes about 90 seconds to run. Does

Re: SSIS Timeout error

Allan Mitchell
8/1/2006 1:34:16 PM

Why do you need to use the DataReader Source adapter to go against SQL
Server. I personally would be the using OLEDB source adapter and connection
manager.

--

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"mystical potato" <mysticalpotato@discussions.microsoft.com> wrote in
message news:B096C169-A100-416B-B3FC-5D5573327A58@microsoft.com...
[quoted text, click to view]