-1

I have 20 SSIS packages and want to put all packages in a single package to run as a single package with same destination table.Is that possible? If possible Can anyone help me how?

chanti
  • 9
  • 4
  • 3
    Yes it is possible but it seems to me you haven't made any effort to work it out. Have you create a master package yet? – Nick.Mc May 09 '17 at 05:13
  • As @Nick.McDermaid said use a MasterPackage and inside the Master package use ExecutePackageTask which can call other package. – observer May 10 '17 at 10:07

1 Answers1

1

You can use Execute Package Task Refer: https://learn.microsoft.com/en-us/sql/integration-services/control-flow/execute-package-task-editor

or you can execute from script Task

public void Main()
    {
        Dts.TaskResult = (int)ScriptResults.Success;
        Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
        Package package = app.LoadFromSqlServer("\OptionalFolderButSlashRequired\ChildPackage", "server", null, null, null);
    }
Samanvitha - user2519049
  • 374
  • 1
  • 7