I reviewed some of the other tek-tips but I didn't see a resolution that would resolve this issue.
The user assures me that after he edited it, it was still in the same format, but that cannot be the case because of this error. I want to get some clarification that a file format error is the only thing this could be or should I be looking at something else.
Fortunately because this is a correction file it is only 16 lines instead of the full size.
The file is imported within an application but the error log for the process stated the following:
SQL Error--8152
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated
I tried loading the file directly through DTS and I recieved the following error.
DTSTransferCopy: Schema Validation Failed. Source column too narrow to contain a valid of destination's column's datatype for column. This error showed up for both date fields in the file.
Date Field(from input file): 2004-02-2912:00
IMPORT TABLE: CHAR 8 DATETIME (date field)
The user assures me that after he edited it, it was still in the same format, but that cannot be the case because of this error. I want to get some clarification that a file format error is the only thing this could be or should I be looking at something else.
Fortunately because this is a correction file it is only 16 lines instead of the full size.
The file is imported within an application but the error log for the process stated the following:
SQL Error--8152
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated
I tried loading the file directly through DTS and I recieved the following error.
DTSTransferCopy: Schema Validation Failed. Source column too narrow to contain a valid of destination's column's datatype for column. This error showed up for both date fields in the file.
Date Field(from input file): 2004-02-2912:00
IMPORT TABLE: CHAR 8 DATETIME (date field)