Link to home
Start Free TrialLog in
Avatar of chokka
chokkaFlag for United States of America

asked on

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
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

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
Avatar of chokka

ASKER



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.
ASKER CERTIFIED SOLUTION
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial