job fails

I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.look here

http://support.microsoft.com/default.aspx?scid=kb;en-us;223758

Originally posted by aadil
I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.|||Also

http://search.microsoft.com/search/results.aspx?st=b&na=83&qu=80040E14&View=en-us

Originally posted by aadil
I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.|||Also this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule DTS as job and resolve the issue.