How can I execute SSIS package as a job, which will stop execution automatically on completion of process?

Posted on 2007-08-12
Medium Priority
Last Modified: 2013-11-05
I am using SQL Server 2005 with Windows XP Pro. I have scheduled execution of SSIS package using SQL Job which goes on for ever, even on completion of the process job still continues to run. How can I stop execution of SSIS package once the process is complete.
Question by:tejas4patel
LVL 18

Accepted Solution

Yveau earned 300 total points
ID: 19680014

A quick look at your question makes me think of two possible thing that might go wrong:
1. Job schedule is not defined the way you want it to act. In that case open the job properties and change the schedule to a more appropriate behavior.
2. There is something wrong with the SSIS package itself that causes this loop.

When the first is the case, it's pretty straightforward. When the latter is the case, you might have a challenge. You might want to run the SSIS from outsite the SQL Server agent as see whether it keeps on running as well. If that's the case you've traced the source of the problem: the SSIS package itself causes the loop to occur. If this run however stops when processing is done, the SQL Server agent and/or the job definition should be blamed for the endless loop.

Do some testing and please share the results with us so we can help you stop this non desired behavior.

Author Comment

ID: 19688262
I recreated SSIS package, and now it is working. Thank you Yveau.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question