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

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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)
Labels
657 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?

657 Views
0 Likes