Hi friends, Below is my SSIS 2005 issue. I have SSIS 2005 Package. Sometime because of some other dependancy and blocking issue, it is still running for more than 10 mins without doing anything. I would like to exit and stop SSIS package, it is still runnign for more than 10 mins. How can i figure out that, package is running for more than 10 Mins and if then how to EXIT from the Package ? let me know if you need more information. Thanks.

Below is a related post. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5194afd1-bbb9-4aff-af8e-b7da71008558/ I may be wrong but give this a try... Can you briefly describe your control flow. If possible try designing the package. For example if you have a task that waits for say 10min and then do something, in that task you can also check to see if it has been more than 15 min since the package execution started and if true you can quit from package execution.There is also a StartTime system variable which gives the time that the package started to run. You can do a datediff between starttime and getdate to see if it's more than 15min.

How can we Query to Report Server and Check the Status of that , is it still Running or Locked Out ? Can we write query to access the property of Report Server and it's Status in SSMS ? Thanks.

Hi all, The last question is related to first? You want query Report Server to know the execution status of a package? Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

Hi all, The last question is related to first? You want query Report Server to know the execution status of a package? Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

Thanks for the replying me. I want query Report Server to know the status of the Reporting Service Account (Report Server).

Thanks for the replying me. I want query Report Server to know the status of the Reporting Service Account (Report Server). This is not very clear. Do you want to have a way to check the status of of SSRS service (running vs stopped)? or do you mean something else? In general, before including logic to halt executions based on time, it may be better to figure out what os causing the lovking issues and to address the root of the issue if possible.Help Others! Don't forget to mark your thread as answered

Thanks for the replying me. I want query Report Server to know the status of the Reporting Service Account (Report Server). It seems this is a SSRS question. If so, you can post question to SSRS forum: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads Regarding to stopping a SSIS package, if it’s a SQL Job, you can use sp_stop_job. Otherwise please check the link Samuel posted, or you can simply kill the executing SSIS dtexec process. If you want to stop package programmatically, you can refer to: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/d8deb945-f3e2-4579-bd5a-86ba2ca07adc Hope this helps, Raymond Raymond Li - MSFT