Hi, I receive error message 8017: The UserId, Password or account is invalid while trying to load data using fast load. All the files are saved in Desktop.
********** Fast Load Script**************
The error explains the problem.
The logon credentials are not correct.
Can you connect to the DBS using BTEQ and those same credentials?
Please use . (dot) before login i.e
Also check once Username and Password.
Let me know if you facing any issue.
. (dot) not manditory in fastload. But it is a good practice to keep the dot.
I think you need to check two things.
1) ping the server from your command prompt and see if the server is up or not
c:\> ping 10.61.59.93
Check the response. if it reply with the packets then good.
2) check your user id through bteq interactive login and verify the credentials
.logon 10.61.59.93/796207 (type enter)
password: Wpwp123 (invisible for you. buy type the password and press enter)
Verify if it logs in. Need to confirm your userid has no problems here and proeed for fasltoad .
Credentials are correct. The problem was, I should have mentioned what mechanism I should be using to connect.
Adding below line at the top solved my problem
Problem solved.. :)
I do not know how to close this.