Solved

SSIS Package - How to start and end the Task

Posted on 2010-11-22
3
775 Views
Last Modified: 2012-05-10

I am quiet new for SSIS.

Under Control Package -

I have created

Task Scheduler - This works.

But Import taken, this project is still running.

As like Start, once Import is done successfully - will it be possible to get stop automatically.
ssis-workflow.jpg
0
Comment
Question by:chokka
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Expert Comment

by:Reza Rad
ID: 34191819
in BIDS, you should stop debugging manually,
but if you deploy the package and run it from sql server job or with DTEXEC command, it will finish after running automatically
0
 

Author Comment

by:chokka
ID: 34191842


This Project will be called from Business layer - Class Project.

So you say that in general SSIS Execution will stop automatically as soon as Import is done successfully.
0
 
LVL 30

Accepted Solution

by:
Reza Rad earned 500 total points
ID: 34191877
>>So you say that in general SSIS Execution will stop automatically as soon as Import is done successfully<<
yes, of course,

and you can run a package from .NET application in this way:
http://msdn.microsoft.com/en-us/library/ms136090.aspx
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 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