I got this strange error message I couldn't get rid of no matter what i tried. It is an SSIS package developed using Visual Studio Prof. 2012 and database is SQL Server 2012.
我得到了这个奇怪的错误信息，无论我怎么努力，我都无法摆脱。它是一个SSIS包开发使用Visual Studio教授2012和数据库是SQL Server 2012。
Message reads this:
消息读取:
[OLE DB Source [85]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Source.Outputs[OLE DB Source Output].Columns[ProductionMultp]" failed because error code 0xC0209075 occurred, and the error row disposition on "OLE DB Source.Outputs[OLE DB Source Output].Columns[ProductionMultp]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[OLE DB Source[85]]错误:SSIS错误代码dts_e_inducedtransformureonerror。“OLE DB数据源。输出(OLE DB源输出)。列[ProductionMultp]“失败是因为错误代码0xC0209075发生了，而错误行配置在”OLE DB源代码上。输出(OLE DB源输出)。列[ProductionMultp]“指定错误的失败。在指定组件的指定对象上发生错误。在此之前，可能会出现错误消息，并提供有关失败的更多信息。
This happens at the time of creating source data in OLE DB Source Editor. I tried to convert source data to the right data type needed in the destination within the source sql command, I tried to the conversion using Data Conversion tool in SSIS, I tried to use both with no avail...
这是在OLE DB源编辑器中创建源数据时发生的。我尝试将源数据转换为源sql命令中目标所需的正确数据类型，我尝试使用SSIS中的数据转换工具进行转换，我尝试使用两者都没有用…
Anybody familiar with that sort of message???
有人知道这类信息吗???
By the way, there is no NULLs in the data nor any value is greater than allowed number of digits in given data type...
顺便说一下，数据中没有空值，在给定数据类型中，任何值都大于允许的位数。
1 个解决方案
#1
2
Go to Advanced Editor for OLE DB Source by right clicking on 'OLE DB Source' / 'Show Advanced Editor...'. Go to the tab 'Input and Output Properties' and expand the option 'OLE DB Source Output' then expand 'Output Columns'. Find your field that is mentioned in the error message and click on it. On the right hand side 'Common Properties' show, find Data Type Properties / Data Type and Length there. Change the data type to what needs to be for that field. That worked fine in my case, I hope it helps you too.
通过右键点击“OLE DB Source”/“Show Advanced Editor…”来为OLE DB Source提供高级编辑器。切换到选项卡的“输入和输出属性”，并扩展选项“OLE DB源输出”，然后扩展“输出列”。找到错误消息中提到的字段并单击它。在右边的“公共属性”显示，查找数据类型属性/数据类型和长度。将数据类型更改为该字段需要的内容。这在我的情况下很管用，我希望它也能帮到你。
#1
2
Go to Advanced Editor for OLE DB Source by right clicking on 'OLE DB Source' / 'Show Advanced Editor...'. Go to the tab 'Input and Output Properties' and expand the option 'OLE DB Source Output' then expand 'Output Columns'. Find your field that is mentioned in the error message and click on it. On the right hand side 'Common Properties' show, find Data Type Properties / Data Type and Length there. Change the data type to what needs to be for that field. That worked fine in my case, I hope it helps you too.
通过右键点击“OLE DB Source”/“Show Advanced Editor…”来为OLE DB Source提供高级编辑器。切换到选项卡的“输入和输出属性”，并扩展选项“OLE DB源输出”，然后扩展“输出列”。找到错误消息中提到的字段并单击它。在右边的“公共属性”显示，查找数据类型属性/数据类型和长度。将数据类型更改为该字段需要的内容。这在我的情况下很管用，我希望它也能帮到你。