Endgame Viable

Avoiding SSIS query timeouts

Tom 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. You may have arrived here by redirection from the original permalink.

Elsewhere: Loading...

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.