On 2020/05/18 23:45, Carlos Augusto wrote: > Hi Guys, > > I'm facing a issue related to command timeout when using psqlodbc. > > When i tried to copy data from a remote postgresql database to a sql > server database, i'm get the following error: > > Do you know how to fix this? > > Error 0xc0047062: Data Flow Task 1: System.Data.Odbc.OdbcException > (0x80131937): ERROR [57014] ERROR: cancelling command because of the > command timeout; > Error while executing the query > at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, > RetCode retcode)
Could you please try to set System.Data.Odbc.OdbcCommand.CommandTimeout=0 ?
regards, Hiroshi Inoue
> 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(CommandBehavior behavior) > at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior > behavior) > at > System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior > behavior) > at > Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute() > at > Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 > wrapper) (SQL Server Import and Export Wizard) > > Error 0xc004701a: Data Flow Task 1: Source 1 - alarme_ciclo failed the > pre-execute phase and returned error code 0x80131937. > (SQL Server Import and Export Wizard)