Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AGurau1639681093
Contributor II
Contributor II
‎2023-01-18 03:28 PM

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)
305 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2023-01-19 08:36 AM

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?

305 Views
0 Likes