One Star

tMSSQLOutput issue

I have a very simple job that is attempting to load a csv file into a SQL Server table.  There is a tFilterow component between the tfileInputDelimited and the tMSSQLOutput components.  When executing the job, I receive the following error:

xception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the PreparedStatement object is closed.
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.checkOpen(
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setInt(
at voyager.sqlservertest_0_1.SQLServerTest.tFileInputDelimited_1Process(
at voyager.sqlservertest_0_1.SQLServerTest.tMSSqlConnection_1Process(
at voyager.sqlservertest_0_1.SQLServerTest.runJobInTOS(
at voyager.sqlservertest_0_1.SQLServerTest.main(


The connection object for SQL Server appears fine and I am able to insert rows into this table via command line.  Thank you!



One Star

Re: tMSSQLOutput issue

I figured this one out.  Had a tMSSQLCommit that was closing the connection