Solved

DTS - Trouble converting Oracle Date columns to SQL Server DateTIme

Posted on 2001-06-17
2
284 Views
Last Modified: 2008-02-26
I'm trying to copy data from an Oracle source table  (using the MS OLE DB for Oracle option) to a MS SQL Server 7  table. It works fine except for the two Date columns (by default
converted to DateTIme in SQL Server).
The only odd thing I notice, is that when I preview the Oracle source, some of the years look too old (1844 for example),but even those should convert to DateTime....
How do I approach this?
0
Comment
Question by:vd
2 Comments
 
LVL 3

Accepted Solution

by:
arun04 earned 100 total points
ID: 6201626
The minimum year supported by SQL Server is 1752, if your data has year older then this , then there is a problem. in that case you can use a char column to store the data
0
 

Author Comment

by:vd
ID: 6202448
Thanks. That was my first thought too,  to change the destination to char. It didn't
work at that time, but it works now for some reason!

Great answer, and I appreciate your quick response!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now