Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS Mapping fields
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
DTS Mapping fields
Miscellaneous
Thread ID:
00436700
Message ID:
00436700
Views:
64
In Oracle it is passable that a datetime field is set to "01/01/1800 12:00:00 AM". The DTS Data Transfer will not work because the datetime type in SQL Server cannot lower then "01/01/1950 12:00:00 AM".

Is there a way to have the field converted from Oracle to a String type in SQL Server with in the DTS process?
Jean-René Roy President of http://www.softdesign.qc.ca/
President of http://www.DevTeach.com and http://www.SQLTeach.com
Next
Reply
Map
View

Click here to load this message in the networking platform