You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

This should be really simple... newbie here
All I want to do is move sql server tables to access (to start).
I have tMSSqlInput to tMap to tAccessOutput
The Access DB is empty and I have Action on Table set to Create table if not exists. Action on data = Insert
When I run it I get this error
Starting job PTMS_Sql_To_Access at 07:45 02/10/2008.
Exception in component tAccessOutput_1
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at ptms.ptms_sql_to_access_0_1.PTMS_Sql_To_Access.tMSSqlInput_1Process(PTMS_Sql_To_Access.java:2368)
at ptms.ptms_sql_to_access_0_1.PTMS_Sql_To_Access$1.run(PTMS_Sql_To_Access.java:3396)
Job PTMS_Sql_To_Access ended at 07:45 02/10/2008. [exit code=1]
Any idea? It seems there is a syntax error in the create table statement. IF that is really what is going on here, how can I fix it?
Offline
Pages: 1