Hi All, I am using the following sql in execute sql task in an ssis package. It takes at leats 10 minutes if I run it in BIDS. However, if I run it using SQL agent, it finished with in 5 seconds. I have a few other tasks in the package that need to be executed *after* this. Any thoughts on this would be greatly appreciated! EXEC msdb.dbo.sp_start_job DataLoad DECLARE @Dummy INT SET @Dummy = 1 WHILE(@Dummy = 1) BEGIN IF EXISTS(SELECT 1 FROM msdb.dbo.sysjobs J JOIN msdb.dbo.sysjobactivity A ON A.job_id=J.job_id WHERE J.name= DataLoad' AND A.run_requested_date IS NOT NULL AND A.stop_execution_date IS NULL) WAITFOR DELAY '00:05' ELSE SET @Dummy = 0 END

typically BIDS takes longer time than executing from sql server agent job or via DTEXEC and reason is debugging environment and visualizing UI for feedback, But this shouldn't take 10 minutes, you are right this is not usual. another thought is that: you run BIDS on local/dev machine which is different than production, so if your connection to production (I mean Lan or any other connection) has quality issues you may affected by this. for testing that thought: you can run same sql statement in Execute SQL Task with a connection to local sql server to see result. running another sql statement via Execute SQL Task will be also helpful.http://www.rad.pasfu.com