SSIS 中 Oracle 到 SQL2005 DATETIME 字段溢出 [英] Oracle to SQL2005 DATETIME field overflows in SSIS

问题描述

我正在使用 SSIS 将数据从 Oracle 导入 SQL Server 2005.我认为 Oracle 中的日期时间字段的存储精度高于 SQL Server 2005DATETIME"字段所允许的精度，从而导致溢出错误.获得桌子的最佳做法是什么?

I'm importing data from Oracle to SQL Server 2005 using SSIS. I think the datetime fields in Oracle are stored to a higher precision than SQL Server 2005 "DATETIME" fields will allow, causing overflow errors. What's the best practice for getting the table in?

这些表有很多日期时间字段，而且有很多表，所以如果每个字段没有大量的手动工作就很棒...

These tables have lots of datetime fields, and there are lots of tables, so it'd be awesome if there wasn't a ton of manual work for each field...

我已阅读 https://stackoverflow.com/questions/2231028/dealing-with-timestamp-datetime-when-copying-data-from-oracle-to-sql-server-using 以及可以工作，但我必须为每个字段、每个表都这样做，而且我宁愿有一个通用的设置或过程......

I've read https://stackoverflow.com/questions/2231028/dealing-with-timestamp-datetime-when-copying-data-from-oracle-to-sql-server-using and that could work, but I'd have to do that for each field, for every table, and I'd rather have a universal setting or process...

有什么想法吗?

推荐答案

只是将其标记为已回答"，因为似乎没有全局设置.

Just flagging this as 'answered' since there appears to be no global setting.

这篇关于SSIS 中 Oracle 到 SQL2005 DATETIME 字段溢出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！