Hi, I am trying to call a stored proc from my SSIS package. The proc uses one table on which I have 6-7 indexes created. Still it is taking lot of time to fetch data in package from a proc. Will Database Engine Tuning Advisor help me in any way.

Try to execute the procedure in SSMS and see the performance of the procedure. First you have to make sure where the problem lies. Is it SP or SSIS Package? Please let us know your observation.Nitesh Rai- Please mark the post as answered if it answers your question