topic tmssqlbulkexec - Exception in component tmssqlbulkexec_1 ..... in Talend Studio

tmssqlbulkexec - Exception in component tmssqlbulkexec_1 .....

Anonymous — Sat, 16 Nov 2024 13:59:55 GMT

Am using a tmssqlbulkexec component in order to load a previously created .csv file using the tmssqoutputlbulk , but am always getting the message:
Exception in component tmssqlbulkexec_1
java.sql.SQLException: Could not bulk inset because the file 'C:/java/out.csv' could not be opened. Operating system error code 3 (The system cannot find the path specified.).
I have checked the .csv file in the location 'C:/java/' and was able to open it in excel. I used tmssqloutputbulkexec and the same message kept showing?
I am using jasperelt V2.3 and tried it on talend 3.0 with the same message popping up.
I appreciate any help
Thanks....
moujab

Re: tmssqlbulkexec - Exception in component tmssqlbulkexec_1 .....

Anonymous — Wed, 15 Apr 2009 07:04:23 GMT

Hello
I think it is not a component problem, so I search it on internet and find a related question.
Best regards

shong

Re: tmssqlbulkexec - Exception in component tmssqlbulkexec_1 .....

Anonymous — Wed, 15 Apr 2009 11:00:28 GMT

10x it worked .....

Re: tmssqlbulkexec - Exception in component tmssqlbulkexec_1 .....

_AnonymousUser — Thu, 08 Dec 2011 17:36:44 GMT

I face the same issue were i get the following error :
Exception in component tMSSqlBulkExec_1
java.sql.SQLException: Cannot bulk load because the file "E:\XYZ\client_XYTR_ABCD_20110108_part-00492"
could not be opened. Operating system error code 3(The system cannot find the path specified.).
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 cig_migration.rf_mb_subjob_0_1.RF_MB_SUbjob.tMSSqlBulkExec_1Process(RF_MB_SUbjob.java:1144)
at cig_migration.rf_mb_subjob_0_1.RF_MB_SUbjob.tFileList_1Process(RF_MB_SUbjob.java:1064)
Can you please give your inputs on this since the.
I am trying to bulk load data into a MSSQL Database.

Re: tmssqlbulkexec - Exception in component tmssqlbulkexec_1 .....

_AnonymousUser — Thu, 08 Dec 2011 17:36:50 GMT