Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Error Destination during DTS Import, using a query

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-03 : 08:14:08
Justin writes "Error Destination for Row Number 4487167. Errors encountered so far in this task: 1. Insert error, column 1 ('Call Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification

The above was generated when I ran a DTS Import, using a query.

The result of the DTS Import was :-
Create Table Results Step = Complete
Copy Data from Results to Results Step = Error Occurred

Is there an error in my SQL Table or is the error in the data held within my SQL Table ?

Ta."
   

- Advertisement -