<div>
Thanks. That was my first thought too, &nbsp;to change the destination to char. It didn't<br />
work at that time, but it works now for some reason!<br />
<br />
Great answer, and I appreciate your quick response!
</div>


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!

<div>
<div class="content wysiwyg-content">
I'm trying to copy data from an Oracle source table &nbsp;(using the MS OLE DB for Oracle option) to a MS SQL Server 7 &nbsp;table. It works fine except for the two Date columns (by default <br />
converted to DateTIme in SQL Server). <br />
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....<br />
How do I approach this?
</div>
</div>


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?

DTS - Trouble converting Oracle Date columns to SQL Server DateTIme

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.