Yep you were right the task executes successfully. Thanks. But now I have a new issue stemming from this

The execute SQL task which runs the statement exec [dbo].[zKMHP_Proprietary] ?, ?) will run just fine, but the results of this stored procedure need to be inserted into another table. When I modify it to be:

INSERT INTO insert into zKMHP_Staging

exec [dbo].[zKMHP_Proprietary] ?, ?)

the task fails. I know the above statement is correct because if I take it and copy it to SQL Mgmt Studio, then change it to

INSERT INTO insert into zKMHP_Staging

exec [dbo].[zKMHP_Proprietary] '10/1/2007', '12/31/2007')

it runs just fine. Ideally, I'd rather use a data flow task to insert the results of a stored procedure into a table, but just haven't figured out how to do this since there are no outputs at design time. So I've tried using the Execute SQL task instead. But anyway, I'm not sure why it won't run when all I do is add the insert into to the task. Can you see anything else wrong?

Thanks,

Strick