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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-21 : 07:48:57
|
| Al writes "Hi,Have a task of transferring a few million records from a few 100 old Approach files into a new SQL Server 2000 database.There are a number of fields in the approach files that have are times (Which apparoach holds as an 8 digit record)I have built a DTS package to transform every field, and when I test each transformation individually they work, however when I try to run the entire package I get this exception report.(I have covered up the personal info with *'s)Execution Started: 15/02/2007 14:16:21Error at Destination for Row number 90. Errors encountered so far in this task: 1. Error Source: Microsoft Data Transformation Services (DTS) Data PumpError Description:Insert error, column 26 ('AppointmentTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.Error Help File:sqldts80.hlpError Help Context ID:30702 Error Source: Microsoft OLE DB Provider for SQL ServerError Description:Invalid character value for cast specification.Error Help File:Error Help Context ID:0 M R ||J |****** |*** ****** ****** ||****** |************* ||**** ***|***** ******|** *******|||I N S P E C T I O N V I S I T |||||||Y E S |Y E S |09/12/2006|1 0 0 0 0 0 0 0 |105864|0|1|0|0|0|0|0|||||0 1 |A L A S T A I R B R O O K S |07/12/2006|||||||1 7 3 9 2 0 3 3 |||||||0|0||0|0|I N S P E C T I O N V I S I T |||||A L A S T A I R B R O O K S |3 ' B e d ||H a n d U n i t ||07/12/2006|03/11/2006||04/06/1998||04/06/Execution Completed: 15/02/2007 14:16:22Please not the Time field thats reporting the error appears directly after the first date field.Windows Server 2003 with SQL Server 2000RegsAl" |
|
|
|
|
|
SQL2000 DTS Package DateTime fields