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(OdbcHa ndle hrHandle, RetCode
retcode) at
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API
odbcApiMethod) at
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior,
String method, Boolean needReader) at
System.Data.Odbc.OdbcCommand.ExecuteReader(Command Behavior behavior) at
System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(C ommandBehavior behavior)
at
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior
behavior) at
Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceA dapter.PreExecute() at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentH ost.HostPreExecute(IDTSManagedComponentWrapper90 wrapper)

This issue with the DataReader is fixed with the SP1...

"Pasha" wrote: