I have an SSIS package that is pulling data using an ODBC source -> OLE DB dest. Very simple package that only has a few tools in it. Typically the package takes ~45 minutes to copy 14 million rows. In the job log it seems like it got stuck on Validation, meaning it didn’t even start executing, so in theory a connection timeout wouldn’t have helped here.
Is there a universal SSIS package timeout option I can build in?
