Hi jfbroede,
I have also successfully connected to my remote SQL Server and can see my databases! Now I need to figure out how to use my new metadata to create a new DB. |
Please have a look at online document TalendHelpCenteretting up a database connection. Best regards Sabrina |
I have made the connection. But Im still having issues adding/populating the SQL DB.
I have the outputdelimited file, and when I try and run a job to send it to my SQL DB I get this:
Exception in component tMSSqlOutput_1
java.sql.SQLException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
at jeff_test.how_to_setup_join_link_0_1.How_To_Setup_join_link.tFileInputDelimited_1Process(How_To_Setup_join_link.java:1546)
disconnected
at jeff_test.how_to_setup_join_link_0_1.How_To_Setup_join_link.runJobInTOS(How_To_Setup_join_link.java:3090)
at jeff_test.how_to_setup_join_link_0_1.How_To_Setup_join_link.main(How_To_Setup_join_link.java:2955)
Job How_To_Setup_join_link ended at 14:11 03/05/2014.
What am I missing?
Jeff