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