That query should work fine, the only guess I have is the way you are calling it.  Try the following:

exec PROD1.ToLIM.dbo.ToLIM_ExtractIndex @vDB, @vDBTable, 'CIN.CINERGY_LOAD',   'CIN.ESAL_LESS_ORPHAN', 'HOURLY_COLUMNS', '1999-01-01', '2005-03-03'

SQL Server is pretty picky about calls made to stored procedures when parameters are named so I'm guessing that's the issue.