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 |
|
annamecca
Starting Member
1 Post |
 Posted - 2009-04-13 : 18:21:54
|
| I am getting the following error message: (Microsoft Data Transformation Services (DTS) Data Pump (8004202b): TransformCopy 'DTSTransformation__3' conversion error: Conversion invalid for datatypes on column pair 1 (source column 'Actual_Payment_Date' (DBTYPE_WSTR), destination column 'actual_payment_date' (DBTYPE_DBTIMESTAMP)).)Step Error code: 8004206AStep Error Help File:sqldts80.hlpStep Error Help Context ID:0I am pulling dates formatted with mm-dd-yyyy in from an excel spreadsheet into sql 2000 table with datetime field. I'm not sure why it would work one week but not the other. I figured it has to be an issue with the formatting- any ideas? |
|
|
|
|
|
conversion error- DBTYPE_WSTR to DBTYPE_DBTIMESTAM