问题描述
您好,
我尝试使用DTS任务将数据导入DW中,我对配置文件部分有这个错误(其他部分有效)
I try to import data into the DW with the DTS task and I have this error for the profile part (the other parts works)
执行:instance / SELECT GeneralInfo.address_id,GeneralInfo.last_name,GeneralInfo.first_name,GeneralInfo.address_name,GeneralInfo.address_type,GeneralInfo.city,GeneralInfo.region_code ,GeneralInfo.region_name,GeneralInfo.postal_code,GeneralInfo.country_code,GeneralInfo.country_name,GeneralInfo.tel_number,GeneralInfo.tel_extension,ProfileSystem.date_last_changed,ProfileSystem.date_created FROM Address WHERE ProfileSystem.date_last_changed> = {ts'2007-08-21 16 :00:00'} AND ProfileSystem.date_last_changed< = {ts'2007-08-21 16:15:00'}
无法将数据从DBtype 130转换为72,成员:Id
文件:CExImObj: erformDataTransfer(3257)SetColumns调用实例/地址失败。
Executing :instance/SELECT GeneralInfo.address_id , GeneralInfo.last_name , GeneralInfo.first_name , GeneralInfo.address_name , GeneralInfo.address_type , GeneralInfo.city , GeneralInfo.region_code , GeneralInfo.region_name , GeneralInfo.postal_code , GeneralInfo.country_code , GeneralInfo.country_name , GeneralInfo.tel_number , GeneralInfo.tel_extension , ProfileSystem.date_last_changed , ProfileSystem.date_created FROM Address WHERE ProfileSystem.date_last_changed >= {ts '2007-08-21 16:00:00'} AND ProfileSystem.date_last_changed <= {ts '2007-08-21 16:15:00'}
Cannot convert data from DBtype 130 to 72, member: Id
File:CExImObj:erformDataTransfer(3257) SetColumns call for instance/Address failed.
我不明白为什么,
谢谢
Cyril
推荐答案
这篇关于DTS配置文件错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!