问题描述
社区.
我在这里遇到一个奇怪的问题，该问题与从ASP.Net网站调用的SSIS包有关.
也就是说，这是一个使用Microsoft.SqlServer.Dts系列的自写dll，目前可以导出为excel和CSV文件格式.计划进一步的机会.
但是现在我陷入了某种性能问题，这是我绝对无法理解的:
如果我从正常的WinForm-App中使用dll，那么一切都很好，甚至多个调用也可以顺利生成我的导出".
但是，如果我将该dll附加到我的webapp上，则会出现服务器超时，部分导出文件"会生成，有些会丢失.
如果我为一次导出调用dll，我也会得到服务器超时，但是会生成exportfile，大约在10秒钟之内...
所以，嗯?
我用谷歌搜索了该问题，发现一些帖子指出此问题可能是由Team Foundation服务器引起的[，因为这似乎是最有前途的解决方案].
不幸的是，那并没有解决我的问题...
所以我想知道是否有人知道这种奇怪行为的原因是什么...
我将不胜感激.
亲切的问候，
Claudia
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
推荐答案
这篇关于从ASP.NET应用程序运行时，SSIS包的运行速度极慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！