Hello, I am trying to run the Constituent Import utility from the client. I have the text file and the format file prepared and it runs perfectly on our Test system. However when I try to run the same files from the same location on our production system, I get the following errors:
....... may not be a valid directory or the process is unable to access the filepath.
.......file1.txt is not a valid file or the process is unable to access the file.
Error reading format file........ You do not have permission to use the bulk load statement.
As I said, the same files work in our test system so I do not believe it is the files. In trying to problem solve, I added the bulkadmin Server Role to my user on production (although my user in Test does not have this role.)
I've been looking at what differences in permission there might be between production and test and have not found anything.
Does anyone have any hints about what might possibly be wrong?
Many thanks,
Tanya
Does the file live within a directory that is specifically for TEST? In other words, are you certain the LIVE environment can access that location? If you are on RAMP you may need to check with them regarding file access locations. Hope you find a solution.