I have a SQL Server job that loads certain columns from a tab delimited text file into a SQL Server database table.The job was working fine until recently it started throwing the below error.
This error occurs when there are null values in the one the columns that you are trying load to the table.In order to fix the issue, the bulk insert command must be run with the 'KEEPNULLS' option.
For more information on the BULK INSERT with KEEPNULLS see the following link. http://msdn.microsoft.com/en-us/library/ms187887.aspx
No comments:
Post a Comment