Hi, more one problem....
I´m try retry information from PostgreSQL 7.2.1 database.
first problem, i create a ODBC connection, if i try use \"Build Connection String\", put the parameter, server, user, password, etc.. the string create fine, i press the button \"Test Connection\", the messagem \"Connected!\" show me, but, i press the \"OK\" button so save there.. the error: \"Data Provider or other service returned an E_FAIL\" show me !!
I use the ODBC Administration to test, create a connection, include in the ETL, test, and all fine ! in the connection of corse.... now i will go to Transformation, in the read source i select the connection, select source (ODBC), in Source is option i select: \"Select statment\", write my query SQL, fine, click OK to return this page, all records show me in the preview, i edit Validator (fine to), i edit transformation (to the TXT file, for example), always read and test, on the RUN, the error occured:
Information 23/10/2009 17:37:51 Starting Transformation...
Information 23/10/2009 17:37:51 Preparing Writers...
Information 23/10/2009 17:37:51 Writer: {} Writer { } Is Ready
Information 23/10/2009 17:37:51 All Writers are Ready
Information 23/10/2009 17:37:51 Writer: {} Target File: C:\TEMP\projetores.txt
Information 23/10/2009 17:37:51 Processing Data...
Information 23/10/2009 17:37:51 Reader:{} Source Select Statement: Select
duracao,hour, min,mday,mon,year,wday,nome
From
intervalos_arquivados,
salas
Where
salas.placa = intervalos_arquivados.placa And
salas.endereco = intervalos_arquivados.endereco
Error 23/10/2009 17:37:51 Reader:{} SQLExecDirect(FHSMT,PChar ('select count(*) rec_count from (Select
duracao,hour, min,mday,mon,year,wday,nome
From
intervalos_arquivados,
salas
Where
salas.placa = intervalos_arquivados.placa And
salas.endereco = intervalos_arquivados.endereco
) a'), SQL_NTS) Failed: HY000 ERROR: parser: parse error at or near \"rec_count\";
Error while executing the query
Information 23/10/2009 17:37:51 Reader:{} Processed : 0 Record(s)
Information 23/10/2009 17:37:51 Reader:{} Records per second : 0
Information 23/10/2009 17:37:51 Reader:{} Rejected : 0 Record(s)
Information 23/10/2009 17:37:51 Reader:{} Time Taken : 00:00:00
Information 23/10/2009 17:37:51 Writer: {} Wrote : 0 Line(s)
Information 23/10/2009 17:37:51 Transformation Completed
Help-me !!
Tanks
