SQL SERVER Java Error Data Truncation Src

We've now seen the error Data truncation src in the java logs twice in the last year. Unfortunately mapping it a to a SQL Server error message has been difficult. However in both cases this has been caused by putting data into an incompatible field, with an Arithmetic overflow error. Putting a smallint into a tinyint and a bigint into an int.

SQL Server Cannot bulk load because the file could not be opened

After running a Bulk Insert statement against a file I got the following error.

Msg 4861, Level 16, State 1, Line 29
Cannot bulk load because the file “FileName” could not be opened. Operating system error code 5(Access is denied.).

I gave myself and SQL Service account Full control and couldn’t fix it. The setup I was running was Logged into a different Server using RDP, then openned up management studio, and connected to a different server to run the command. The fix was to rdp to the server where I was running sql server. This seemed to fix it. Another blog had a similar situation and fixed using tcp/IP and not named pipes but this didn’t apply to my situation

Blog on similar issue.

http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/thread/7b87d35f-7b08-4727-9544-8dd7035c5e87/