Call a SSIS package inside another

Madhu.b.rokkam
Posted by in Sql Server category on for Beginner level | Points: 150 | Views : 12220 red flag

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.. 

Page copy protected against web site content infringement by Copyscape

About the Author

Madhu.b.rokkam
Full Name: Madhu Rokkam
Member Level: Bronze
Member Status: Member,MVP
Member Since: 1/13/2011 3:13:20 PM
Country: India
Thanks and Regards Madhu
http://www.dotnetfunda.com

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)