Unable to load data from file as source : Location C:\Full_Load_test.csv is not a valid location. Data file(s) location does not exist.

[AKJ]

Hi,

I'm not able to use my CSV file as a source to my Full Load replicate task.

I'm trying to load data from a CSV file to Snowflake hosted on AWS. I can see the target connection working fine with the table getting created, but then the task fails with this error. Please help me to fix this. Am I missing something?  I tried to load a .txt file even, still no luck. Basically I'm not able to use any file as source. 

Note: Followed this particular link to create my source
https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/File/define_table_and_full_load...

 

[SachinB]

Hello @AKJ ,

Could you please cross verify, Whether the above file is existed in above C drive or not? Basically this returns error when file is not existed.

Regards,
Sachin B

[AKJ]

Hi @SachinB ,

The file exists in the mentioned path.

[john_wang · Accepted solution]

Hello @AKJ ,

Looks like a privilege issue. Would you please set SOURCE_UNLOAD to Verbose and recreate the error, then check the task log file to understand the root cause further. Or put the .csv file to other drive, eg D:\temp for comparison.

Regards,

John.