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

Posted on 2007-08-12
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


    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

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now