Create Temp table to store the data instead of using cursor.

Sorry guys, I found the reason why I hit the error.

It is due to I inserting a empty value to a not nullable field.

Problem Solved by using UNC Path to do the file location.

Thanks

I already put the access to 'Everyone'. But still facing the same error.

2server are located different IP and Port.

Yes, It facing the same problem, if I run from the SSIS package, But if I change the directory to local, it does not face the problem.