SSIS Initial Startup

Hi All,

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.

1. Uncheck for publisher's certificate revocation


2. 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