• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1591
  • Last Modified:

Microsoft SQL Server: DTS error, status 6: Data overflow

I'm importing files from a Cegid (kind of foxpro-ish compatible) database.  When I run my DTS package some of the tables import just fine, but others throw multiple errors.  When I double click on the errors, I get a box that says something like this:

Error at Destination for Row number 1.  Errors encountered so far in this task: 1.
Insert error, column 88 ('tv_dsid', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error, column 87 ('tv_dcap', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error, column 86 ('tv_dcal', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error, column 79 ('tv_dcac', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.

I assume this means that the data transformation engine guessed wrong on those particular columns.  So I created a linktable in access to view the data, and Access show that those aprticuar columns are filled entirely with the data "12:00:00 AM". When I open the linktable in designmode Access thinks that field is a "date/time"

Since I'm really new to SQL Server in general, I'm wondering if I could get some expert opinion and assistance working this out.  Any ideas?
0
AptDev
Asked:
AptDev
  • 2
1 Solution
 
SireesCommented:
0
 
SireesCommented:
Problem is  conversion types. Look at the datatypes for Source table and compare them to the datatypes of the target sql server table. if there are any Char to Numeric/Integer or Char to Date and other such assumed conversion then there is your problem.

you can use DTS to handle such errors and use DTS transformation scripts to descide if you want to abort the transfer, ignore the row or create an error file.

You can look at the rows 88,87,86 and 79 to see why it failed?
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now