This article explains about how we can call an SSIS package from another.
Introduction
SSIS has many control flow tasks to perform various activities and Execute package task is one of them.
So lets start and see how it works.
In this part one we will try to call a package from File system.
Start MS BI Development Environment, Select and Integration services project.
Drag drop a Execute Package Task on to the package as shown.
Double click on the task to configure as shown, Select the location to be File System
Finally Click ok
Thats it.. Execute the package and see the result
Since the package that we called from this package here is Conditional Split in SSIS that we created earlier.
We will get the same result that we got there i.e. two separate files got created. Please refer to this link for details.
http://www.dotnetfunda.com/articles/article1214-conditional-split-in-ssis-.aspx
Simple... Hope you all like this article..