tAccessOutputBulkExec

[Anonymous]

Hello, i am trying to use tAccessOutputBulkExec because i need to write milions of rows into Access DB.

I am able to write using the standard tAccessOutput component but the action requires lot of time so that's the reason why i wanna use the bulk ones.

Unfortunally when i try to use the component i get the error:

Exception in component tAccessOutputBulkExec_1_tABE (Write_date_Into_DB)
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)

looks like thast some .jar file is missing but i don't have any "yellow" advise in the corner ot the tAccessOutputBulkExec which says that any component is missing....

[Anonymous]

And after that the job failed, the csv which i specified in the tAccessOutputBulkExec is emptied. I built this csv with one jobs which output in csv files, i did not use the tAccessOutputBulk. could be this the issue? don't know...

[Anonymous]

Any feedback please?

[Anonymous]

Hello,

Is your Access DB connection OK with you? Are you using Generic ODBC? More information will be preferred.

Best regards

Sabrina