Next: Quick Demon Book Review. Previously: It’s The End Of The World….

Avoiding SSIS query timeouts

90 words.

Just so I have a record of this: In SSIS, I was trying to pull data from a SQL Server database with a complex, slow SELECT query (written by someone else) which took a good 15 minutes to run. I was using a DataReader source, and it would always timeout after about 30 seconds if no rows came back in that time, and I couldn’t find any way to change the timeout. Finally I switched to an OLE DB source with the same query, and it didn’t timeout any more.

Related

Next: Quick Demon Book Review. Previously: It’s The End Of The World….

This page is a static archival copy of what was originally a WordPress post. It was converted from HTML to Markdown format before being built by Hugo. There may be formatting problems that I haven't addressed yet. There may be problems with missing or mangled images that I haven't fixed yet. There may have been comments on the original post, which I have archived, but I haven't quite worked out how to show them on the new site.

Sorry, new comments are disabled on older posts. This helps reduce spam. Active commenting almost always occurs within a day or two of new posts.