|
Home > Archive > MS SQL Server DTS > April 2006 > SSIS ODBC Query Time Out
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SSIS ODBC Query Time Out
|
|
|
| Hi All,
I'm trying to execute a 2005 package that retrieves data using the IBM
RedBrick ODBC drivers and I get a time-out message. I can't find the option
to set this time-out value to 0. I'm using the
ADO.NET:System.Data.Odbc.OdbcConnection and DataReader Source in the
DataFlow. How can I fix this issue? Below is the error that I get.
[Retrieve Employees from STS [1]] Error: System.Data.Odbc.OdbcException:
ERROR [HYT00] [Red Brick][ODBC Driver]** ERROR ** (10699) Query timed out
after 30 seconds. at
System.Data.Odbc.OdbcConnection. HandleError(OdbcHand
le hrHandle, RetCode
retcode) at
System.Data.Odbc.OdbcCommand. ExecuteReaderObject(
CommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API
odbcApiMethod) at
System.Data.Odbc.OdbcCommand. ExecuteReaderObject(
CommandBehavior behavior,
String method, Boolean needReader) at
System.Data.Odbc.OdbcCommand. ExecuteReader(Comman
dBehavior behavior) at
System.Data.Odbc.OdbcCommand. ExecuteDbDataReader(
CommandBehavior behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand. ExecuteReader(Comman
dBehavior
behavior) at
Microsoft.SqlServer.Dts.Pipeline. DataReaderSourceAdap
ter.PreExecute() at
Microsoft.SqlServer.Dts.Pipeline. ManagedComponentHost
. HostPreExecute(IDTSM
anagedComponentWrapp
er90 wrapper)
| |
|
| This issue with the DataReader is fixed with the SP1...
"Pasha" wrote:
> Hi All,
>
> I'm trying to execute a 2005 package that retrieves data using the IBM
> RedBrick ODBC drivers and I get a time-out message. I can't find the option
> to set this time-out value to 0. I'm using the
> ADO.NET:System.Data.Odbc.OdbcConnection and DataReader Source in the
> DataFlow. How can I fix this issue? Below is the error that I get.
>
> [Retrieve Employees from STS [1]] Error: System.Data.Odbc.OdbcException:
> ERROR [HYT00] [Red Brick][ODBC Driver]** ERROR ** (10699) Query timed out
> after 30 seconds. at
> System.Data.Odbc.OdbcConnection. HandleError(OdbcHand
le hrHandle, RetCode
> retcode) at
> System.Data.Odbc.OdbcCommand. ExecuteReaderObject(
CommandBehavior behavior,
> String method, Boolean needReader, Object[] methodArguments, SQL_API
> odbcApiMethod) at
> System.Data.Odbc.OdbcCommand. ExecuteReaderObject(
CommandBehavior behavior,
> String method, Boolean needReader) at
> System.Data.Odbc.OdbcCommand. ExecuteReader(Comman
dBehavior behavior) at
> System.Data.Odbc.OdbcCommand. ExecuteDbDataReader(
CommandBehavior behavior)
> at
> System.Data.Common.DbCommand.System.Data.IDbCommand. ExecuteReader(Comman
dBehavior
> behavior) at
> Microsoft.SqlServer.Dts.Pipeline. DataReaderSourceAdap
ter.PreExecute() at
> Microsoft.SqlServer.Dts.Pipeline. ManagedComponentHost
. HostPreExecute(IDTSM
anagedComponentWrapp
er90 wrapper)
|
|
|
|
|