It actually pulls in data from both sources, hence the union all task and the script. If you can imagine, one source pulls all the data successfully, the other is...

Got around this by putting in an additional excel source (formatted for excel 2003) and a union all task. Only one of the excel sources will successfully output the data...

Thanks for the replies.

I'll change the way I'm doing this, rather than use 1 stored proc to handle all possible entries from the user I'll split it down into...

Mmmmm... I have created a Clustered index on BusinessObjectInstanceId, BusinessObjectTypeFullName, Timestamp and there is a small improvement, but not siginficant enough to warrant the hit on the index rebuilds that...

Tried using OR @BusinessObjectInstanceId = 0 with no difference to the execution time

The parameter is being passed into this stored procedure and could be empty depending on what the user...

Do you have any suggestions for the index (es)? The query in the original post will be used far more than any other. I have tried a non clustered index...