Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AGurau1639681093
Contributor II
Contributor II

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

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.

Labels (4)
1 Reply
Anonymous
Not applicable

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?