I am getting below error when, I am trying to load data from text file to mssqloutput.
Error:
Starting job bapitest at 18:45 22/11/2018.
[statistics] connecting to socket on port 3478 [statistics] connected Exception in component tMSSqlOutput_1 (bapitest) com.microsoft.sqlserver.jdbc.SQLServerException: 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 com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:903) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:796) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183) [FATAL]: sga_data_lake.bapitest_0_1.bapitest - tMSSqlOutput_1 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. com.microsoft.sqlserver.jdbc.SQLServerException: 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 com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:903) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:796) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:769) at sga_data_lake.bapitest_0_1.bapitest.tFileInputDelimited_1Process(bapitest.java:1000) at sga_data_lake.bapitest_0_1.bapitest.runJobInTOS(bapitest.java:1702) at sga_data_lake.bapitest_0_1.bapitest.main(bapitest.java:1444) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:769) at sga_data_lake.bapitest_0_1.bapitest.tFileInputDelimited_1Process(bapitest.java:1000) at sga_data_lake.bapitest_0_1.bapitest.runJobInTOS(bapitest.java:1702) at sga_data_lake.bapitest_0_1.bapitest.main(bapitest.java:1444) [statistics] disconnected Job bapitest ended at 18:45 22/11/2018. [exit code=1]
