ole db连接失败的事件处理程序 [英] event handler for ole db connection failure
问题描述
我的ssis包由DFT，（Extract）组成，包含：
- Ole db源对多维数据集运行查询
- Ecozyroc Excel目标将数据转储到excel
我面临的问题是断断续续的。有时候我会面对以下问题错误拒绝连接到多维数据集。在这种情况下，DFT失败并且整个包失败。我通过失败的作业运行它。但是，如果我在几分钟后从代理作业重试，它就可以工作。
我希望程序包继续运行，在数据包中等待几分钟并继续下一次迭代。我试图通过事件处理程序设置propagate = false捕获此错误，保留相同的连接= true，但所有内容都在徒劳。
我看到很多护目镜结果表明它无法处理这个事件，并建议如下所示的脚本任务，但想知道是否还有其他方法。
包裹：
嗨 msdnpublic1234，
我希望包继续运行，等待几分钟wi瘦包并继续下一次迭代。
我想知道你是否要延迟包的控制流程？
如果所以，请参阅
在SSIS中暂停。
最诚挚的问候，
Mona Lv
Hi,
My ssis package consist of DFT,(Extract) containing:
- Ole db source running a query against a cube
- Ecozyroc Excel destination to dump data into excel
The issue i face is intermittent.Sometimes I face the following error refusing to connect to the cube.In this case,the DFT fails and whole package fails .I am running this via a job which fails.However ,if i retry from agent job after few mins,it works.
I want the package to continue running with either waiting a few mins within package and continue with next iteration.I tried to catch this error via event handler setting propagate=false,retain same connection=true,but everything in vain.
I see lot of goggle results stating it is not possible to handle this event and suggested a script task like below,but wanted to know if there is another way.
https://stackoverflow.com/questions/15302274/ssis-looping-through-servers-and-handling-failed-logins
Also,i have attached an image of how my package looks like:
the for loop loops through the object containing user emails and for each email, a query runs to pull data for that user,dumps them into excel and uploads the file in sharepoint.What breaks at times is the connection to the cube in DFT.
This is the error i see:
Hi msdnpublic1234,
I want the package to continue running with either waiting a few mins within package and continue with next iteration.
May I know if you want to delay the control flow of the package?
If so, please refer to Pause in SSIS.
Best Regards,
Mona Lv
这篇关于ole db连接失败的事件处理程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
