Endgame Viable

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.

Originally posted on my personal blog which was active from 2003 to 2020.

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.