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(JtdsPreparedStatement.java:406)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.getParameter(JtdsPreparedStatement.java:558)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:630)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setInt(JtdsPreparedStatement.java:808)
at voyager.sqlservertest_0_1.SQLServerTest.tFileInputDelimited_1Process(SQLServerTest.java:3396)
at voyager.sqlservertest_0_1.SQLServerTest.tMSSqlConnection_1Process(SQLServerTest.java:2184)
at voyager.sqlservertest_0_1.SQLServerTest.runJobInTOS(SQLServerTest.java:7052)
at voyager.sqlservertest_0_1.SQLServerTest.main(SQLServerTest.java:6592)

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: tMSSQLOutput issue

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

1 REPLY
One Star

Re: tMSSQLOutput issue

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