topic using tDBOutputBulkExec - error :can't access file .... in Talend Studio

using tDBOutputBulkExec - error :can't access file ....

AGurau1639681093 — Fri, 15 Nov 2024 22:11:24 GMT

Newbie here.

While trying to copy the entire content of a table (1.5 mil records) from Oracle to SQL Server using tDBOutputBulkExec I get this weird error

tDBOutputBulkExec_1_tMBE Cannot bulk load. The file "C:/Temp/mssql_data.txt" does not exist or you don't have file access rights.

The file is there, I checked.

I am attaching a screen shot. What am I missing? Please advise. Thanks you so much in advance.

Re: using tDBOutputBulkExec - error :can't access file ....

Anonymous — Thu, 19 Jan 2023 13:36:21 GMT

I think this is caused because the file you are using needs to be accessible by the database that you are loading to. You are actually getting the db to process the file.

The documentation for this component does briefly mention this here....

https://help.talend.com/r/en-US/7.3/oracle/toracleoutputbulkexec

It's an easy one to miss though. Can you relocate the file to be accessible by the DB?