Thanks for all. .

I wrote the query like below.it works well

Select f1,f2,f3

from table

where depart(yyyy,date)=@year and datename(m,date)=@monthname

the following error is getting :

[Execute SQL Task] Error: Executing the query "dbo.sp_capture" failed with the following error: "Invalid object name 'dbo.capture_Tracking'.". Possible failure reasons: Problems with the query, "ResultSet"...

can you please explain me ,how did you solve that pblm?

because, rightnow iam facing same problem.

Thanks for your reply.

Now i am facing another problem,how will i send the data which is exist in temp table?