index portion of code is wrong. It's actually

create NONCLUSTERED INDEX #idx_ID on #ID(ID) include (TID).

But I will run it again without index portion.

I an using following sql code in OLE DB Source:

exec dbo.usp_GetBill_Info @StartDate =?, @EndDate=?