• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 962
  • Last Modified:

SSIS Package - How to start and end the Task


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
chokka
Asked:
chokka
  • 2
1 Solution
 
Reza RadConsultant, TrainerCommented:
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
 
chokkaStudentAuthor Commented:


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
 
Reza RadConsultant, TrainerCommented:
>>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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now