test.guillaume

I found the problem !!! In my ODBC parameter, in 3rd view of the assistant, I forgot to put the default database : AdventureWorksDW instead of master. :blink: :whistle: :woohoo:

thks for your answer :) If I do the same query in Microsoft SQL Server : select FirstName, LastName from DimCustomer I have the good result in SS05 but nothing in Talend :/ Post edited by: test.guillaume, at: 2007/04/02 08:25

Hi, I try to extract 2 fields of the DimCustomer who is a table of the Microsoft SQL Server 05 (AdventureWordksDW sample). I would put the result in an Excel files. DBconnection show me ok when I check with ODBC Generic and M$ SQL Server ODBC. My query : "select FirstName, LastName from DimCustomer" The error : Starting job TEST1_Prior_test at 14:16 28/03/2007. Running process with context: Default Exception in component tDBInput_1 java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Nom d'objet 'DimCustomer' non valide. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253) at talenddemosjava.test1_prior_test.TEST1_Prior_test.tDBInput_1Process(TEST1_Prior_test.java:181) at talenddemosjava.test1_prior_test.TEST1_Prior_test.main(TEST1_Prior_test.java:379) Job TEST1_Prior_test ended at 14:16 28/03/2007. [exit code=0] I use Talend2 M3 ;) Thanks for your help :) posted in talend forum : http://talendforge.org/forum/viewtopic.php?id=445 Post edited by: test.guillaume, at: 2007/03/30 15:26

Oh :blink: I'm so sorry for this little stupid forget :angry: who waste your time :blush: and mine. Thanks for your answer. Read you later Guillaume Post edited by: test.guillaume, at: 2007/02/22 15:43

Thanks for your answer ;) Yes, the statistics mode displays the good number line. I send you all.

hi, I'm testing JasperETL and I found (maybe) a odd bug/problem. I have 3 .xls files in entry and I want to obtain one .xls file with a concatenation and selection. http://img120.imageshack.us/img120/4976/pb1tl6.th.jpg http://img241.imageshack.us/img241/6731/pb2jn8.th.jpg As you can see on these pictures. I have 464 rows then 494 rows. between the 2, I don't do anything (only push "Run") Data in my 3 xls files haven't change. On the last picture, you can see the treatment that I do. http://img412.imageshack.us/img412/1139/pb3vd4.th.jpg I can send you the 3 files, if you want. I thank you for your futures answers and I apologize for my bad frenchy speaking Guillaume Post edited by: test.guillaume, at: 2007/02/20 14:08 Post edited by: test.guillaume, at: 2007/02/20 14:09 Post edited by: test.guillaume, at: 2007/02/20 14:11 Post edited by: test.guillaume, at: 2007/02/20 14:12

Sorry for the 2 post, if a modo can delete this one ;) Post edited by: test.guillaume, at: 2007/02/21 07:25