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
chokkaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Reza RadConnect With a Mentor Commented:
>>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
 
Reza RadCommented:
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
 
chokkaAuthor 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
All Courses

From novice to tech pro — start learning today.