There is a bcp job that does every night processing and every other day it fails. I am not sure how to troubleshoot it. I did not design this job, so I am not sure how things in the job works. But when fails, i need to handle it. On the SQL Server job setting wise everything seems ok.. but to find the root cause of the problem, I am not sure how to handle it. Wondering if there was any bad data in the file, when the data is being dumped into the SQL SERVER. Not sure!. I checked the Windows event viewer SQL SERVER Log, job monitor, error logs.. nothing in specific details that i missing out?
Any ideas on how to trouble shoot the issue ?
Thanks in advance!