I have an SSIS package that copies 68 rows of data from an excel spreadsheet into a table in SQL server. The table has no indexes of any kind, maybe ten columns, mostly numeric, nothing large. The package is run via SQL job every two minutes, piping the data from the Excel spreadsheet into this table.
Most of the time, the package takes between 3 and 5 seconds to complete. However, occasionally, it takes much longer: up to two minutes (yikes!).
There doesn't appear to be a lot going on with the server. It is not running anywhere close to 100%.
I'm at a bit of a loss as to how to begin determining what the issue is here. Does anyone have any ideas?