On a project where we used SSIS for the import of data we've encountered a problem with the initial startup of a task. It took almost 45 seconds just to start the SSIS package before executing it. After some research we've found that the problem was caused by a simple internet setting. Before that the SSIS package starts it will check if there is a certificate for it, because the production database was not connected to the internet a default timeout of 45 seconds was kicked in.
The problem is easy to resolve by unchecking the following in the Internet Settings -> Advanced tab.
- Uncheck for publisher's certificate revocation
- Uncheck for server certificate revocation
After this your SSIS package will run a lot faster. A nice extra feature is that your SQL Management Studio will start a lot faster :).
Regards,
Hilco
