从ASP.NET应用程序运行时，SSIS包的运行速度极慢 [英] SSIS Package extremely slowing down when run from an ASP.NET app

问题描述

社区.
我在这里遇到一个奇怪的问题，该问题与从ASP.Net网站调用的SSIS包有关.
也就是说，这是一个使用Microsoft.SqlServer.Dts系列的自写dll，目前可以导出为ex​​cel和CSV文件格式.计划进一步的机会.
但是现在我陷入了某种性能问题，这是我绝对无法理解的:
如果我从正常的WinForm-App中使用dll，那么一切都很好，甚至多个调用也可以顺利生成我的导出".
但是，如果我将该dll附加到我的webapp上，则会出现服务器超时，部分导出文件"会生成，有些会丢失.
如果我为一次导出调用dll，我也会得到服务器超时，但是会生成exportfile，大约在10秒钟之内...
所以，嗯?
我用谷歌搜索了该问题，发现一些帖子指出此问题可能是由Team Foundation服务器引起的[

Hi, community.
i have a strange issue here relating an SSIS Package that is called from an ASP.Net website.
namely it´s a selfwritten dll that uses the Microsoft.SqlServer.Dts-family to produce exports to excel and CSV fileformat at the moment. further opportunities are planned.
but now i got stuck with kind of performance problems, which i am absolutely unable to to understand:
if i use my dll from within a normal WinForm-App everything is fine and even multiple calls are smoothly generating my ''exports''.
but if i attach that dll to my webapp, i get a server timeout, part of the ''export-files'' are generated, some get lost.
if i call my dll for one single export, i also get a server timeout but the exportfile is generated, approximately within round about 10 seconds...
so, uh?
i googled for that problem and found some postings stating this problem could be caused from Team Foundation server [look here, since that seemed to be the most promising solution].
unfortunately, that did not solve my problem...
so i wonder if someone has an idea what the reason could be for that strange behaviour...
I´d appreciate any tips.
Kind regards,
Claudia

推荐答案

再次，
这不是SSIS问题，只需删除所有断点即可解决问题！[​​CTRL + Shift + F9或通过调试菜单]
这也解释了为什么从WinForm Project调用的同一个dll可以顺利运行的原因. 这是一个与不当行为"有关的解决方案.
亲切的问候，
claudia

Hi, again,
this was no SSIS problem, simply deleting all Breakpoints solved it![CTRL+Shift+F9 or via Debug menu]
this also explains why the same dll called from a WinForm Project served smoothly.
it was a solution related ''misbehaviour''.
kind regards,
claudia

这篇关于从ASP.NET应用程序运行时，SSIS包的运行速度极慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！