Trouble Dropping And Recreateing An Index

Hi,

I get a new payroll data file every two weeks. I have a DTS package that drops the table, creates a new table and then adds an index. The SQL task that checks for the exsistence of an index and then drops and creates a new one is failing. Here is the the SQL for the Execute SQL task

------------------------------------------------------------------------------------------------------------------------------------------


IF EXISTS (SELECT name FROM sysindexes
WHERE name = 'EmpPosTimePerEndDateIndex')
DROP INDEX dbo.EMP_POS_TIME_55_316_TBL.EmpPosTimePerEndDateIndex


GO


CREATE CLUSTERED INDEX EmpPosTimePerEndDateIndex
ON dbo.Payroll_TBL (PER_END_DATE)
GO


----------------------------------------------------------------------------------------------------------------------------------

This task fails and I get the error

Cannot drop the index 'dbo.EMP_POS_TIME_55_316_TBL.EmpPosTimePerEndDateIndex', because it does not exist in the system catalog.

But, SELECT name FROM sysindexes
WHERE name = 'EmpPosTimePerEndDateIndex' returns one record.???????

Maybe I created the index on a different table, but I don't know which one.

Any suggestions. How come sysindexes doesn't have a field for table to associate the index with?

Mike