• 主页
  • 基础类
  • 应用实例
  • 新技术前沿

DTS 的问题

forcast 2004-12-28 09:23:37
我用DTS来导从informix的数据,但是导入的时候出现下面的错误:
The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): ActiveX Scripting Transform 'DTSTransformation__1' encountered an invalid data value for 't_exdt' source column.)
程序如下:请指教:



我注意到用ado方式查询结果,会出现下面的错误:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
State: (null), Native: 0, Source: Microsoft OLE DB Provider for ODBC Drivers
...全文
86 点赞 收藏 3
写回复
3 条回复
forcast 2004年12月29日


DTS and Informix
The Informix ODBC driver is not supported for use with DTS.


The Merant Informix OLE DB provider is supported for DTS imports from Informix, but not DTS exports to Informix. This driver also cannot be used to import meta data.


The Intersolv Informix ODBC driver is supported, but with the following restrictions:
BLOBs cannot be exported to Informix.


When creating new tables on Informix, the DTS Import/Export Wizard will incorrectly map the SQL Server 2000 datetime columns to the Informix 'Datetime year to fraction' data type. Manually change this to the Informix Date type.


The DTS meta data import will not import Informix catalog or table information.
回复 点赞
forcast 2004年12月29日
我想这个问题很难解决,从微软的官方网站上说DTS不支持INFORMIX :
http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_usage_288j.asp
回复 点赞
NinGoo 2004年12月28日
The number of failing rows exceeds the maximum specified

数据类型的问题,你看看t_exdt在导入导出前的类型是什么?
回复 点赞
发动态
发帖子
MS-SQL Server
创建于2007-09-28

1.4w+

社区成员

25.3w+

社区内容

MS-SQL Server相关内容讨论专区
社区公告
暂无公告