SSIS验证失败 [英] SSIS failed validation

问题描述

SSIS< g class =" gr_ gr_44 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace"数据-GR-ID =" 44" id =" 44"> PACKAGE。< / g>

SSIS <g class="gr_ gr_44 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace" data-gr-id="44" id="44">PACKAGE .</g>

源OLEDB Oracle 

Source OLEDB Oracle 

目标SQL服务器。

在SSMS工作 或者< g class =" gr_ gr_102 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear样式中的.dtsx文件gr_disable_appear样式multiReplace"数据-GR-ID =" 102" id =" 102">< g class =" gr_ gr_101 gr-alert gr_gramm
gr_inline_cards gr_disable_anim_appear Grammar only-ins replaceWithoutSep"数据-GR-ID =" 101" ID = QUOT; 101">箱位LT; / g取代; 。< / g>

Working from SSMS  or kicking .dtsx file under <g class="gr_ gr_102 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace" data-gr-id="102" id="102"><g class="gr_ gr_101 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Grammar only-ins replaceWithoutSep" data-gr-id="101" id="101">bin</g> .</g>

我已经< g class =" gr_ gr_325 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace"数据-GR-ID =" 325" ID = QUOT; 325">按照< / g取代; ：

I have already <g class="gr_ gr_325 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="325" id="325">follow</g> :

http://www.sqlservercentral.com/blogs/koen-verbeeck/2013/04/23/force-installation-of-64-bit-ace-ole-db- provider /

http://www.sqlservercentral.com/blogs/koen-verbeeck/2013/04/23/force-installation-of-64-bit-ace-ole-db-provider/

更改项目
属性  Run64BitRuntime  到
False。

changing project property Run64BitRuntime to False.

问题：1。无法在命令行工作（"C：\ Program Files\Microsoft SQL Server \100\DTS\Binn\DTEXEC.exe / File"F：\SSIS \SSISTEST\bin\Package。< g class =" gr_ gr_257 gr -alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling"
data-gr-id =" 257" id =" 257"> dtsx< / g>" ;

Issue : 1. not working from the command line ("C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTEXEC.exe /File "F:\SSIS\SSISTEST\bin\Package.<g class="gr_ gr_257 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling" data-gr-id="257" id="257">dtsx</g>"

< g class =" gr_ gr_267 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace"数据-GR-ID =" 267" id =" 267">错误：< / g>来源< g class =" gr_ gr_255 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear
ContextualSpelling ins-del multiReplace"数据-GR-ID =" 255" ID = QUOT; 255">预言< / g取代; 1 950）验证失败并且< g class =" gr_ gr_268 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear样式multiReplace"数据-GR-ID =" 268"
id =" 268"> return。< / g>

<g class="gr_ gr_267 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace" data-gr-id="267" id="267">Error :</g> Source <g class="gr_ gr_255 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="255" id="255">oracle</g> 1 950) failed validation and <g class="gr_ gr_268 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace" data-gr-id="268" id="268">return .</g>

问题2：不是< g class =" gr_ gr_256 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace"数据-GR-ID =" 256" ID = QUOT; 256">乳宁< / g取代;来自< g class =" gr_ gr_265 gr-alert
gr_gramm gr_inline_cards gr_disable_anim_appear Grammar only-ins replaceWithoutSep"数据-GR-ID =" 265" ID = QUOT; 265"> SQL< / g取代; server< g class =" gr_ gr_269 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace"
data-gr-id =" 269" id =" 269"> agent。< / g>

issue 2: not <g class="gr_ gr_256 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling ins-del multiReplace" data-gr-id="256" id="256">runing</g> from <g class="gr_ gr_265 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Grammar only-ins replaceWithoutSep" data-gr-id="265" id="265">SQL</g> server <g class="gr_ gr_269 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style multiReplace" data-gr-id="269" id="269">agent .</g>

错误：

推荐答案

Hi Kayadhu，

Hi Kayadhu,

您可能需要安装Oracle OLEDB驱动程序

you probably need to install Oracle OLEDB driver

这篇关于SSIS验证失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！