Can someone explain why running a stored procedure through an Execute SQL Task would be slower than executing it via SQL Server Management Studio? I am finding that it is almost a 100 times slower.Regards,
asked Jan 13 '11 at 12:27 AM in Default
Lots of possible causes......
What is the stored procedure doing?
What does the stored procedure return?
Where is the SSIS task executing, with regards to the database server? Same server, over network?
Where are you running SSMS, with regards to database server? On server, over network?
answered Jan 13 '11 at 01:14 AM
Kev Riley ♦♦