Thanks for replying to my post.

The Worktable reads are high.

Table 'Worktable'. Scan count 42611, logical reads 42619, physical reads 0, read-ahead reads 0.

Table 'Worktable'. Scan count 42611, logical reads 42619,...

Thank you.

I will not use 'forceplan'. Will work with just the covering index.

Thanks again.

Yes, after using 'with index', the optimizer still did not use the forced index.

The tables contain around 30,000 rows.

No, did not use 'set forcedplan'. Will try that.

Thanks.

Thanks Matt.

Won't memory be an issue since RETURN TABLE means all that data returned is cached, since the table itself is created in memory?

Thanks Steve.

I did not use an ActiveX Script, however, based on the example in the link that you specified, I will now do so.

Thanks again.

Thanks Greg.

I managed to create the DTS package.