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 |
|
joanne
Starting Member
46 Posts |
 Posted - 2006-11-29 : 21:55:43
|
| Hi, I must transfer an oracle table to sql server with DTS.A column is varchar type in the oracle table and is datetime in sql server table.For the transformation I use this:DTSDestination("col_date") = convert(datetime,DTSSource("col_date"),1)When I run the DTS I have this error:the number of failing rows exceeds the maximum specified.error source:Microsoft VBScript runtime errorError description: Type mismatch:'convert'Could you tell me please what is wrong with my DTS&Many thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-30 : 00:18:00
|
| Which date format is the date stored in ORACLE?Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
convert from varchar to datetime, DTS