SSIS - Referencing This Package in Script

Question

I have an SSIS Package. I need to write a VB.NET (or C#) script task inside the pkg that looks at a specific Sequence Container in the same SSIS Package, cycles through all the executables and stores the names of those executables into an ADO recordset for later use.

I'm stuck on the first step: How do I reference the SSIs pkg from inside?

Dim pkg as Package
pkg = ?

Answer 1

hi ,

you need to read the package from where it is saved.

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.SqlServer.Dts.Pipeline.Wrapper;

using Microsoft.SqlServer.Dts.Runtime;

using Microsoft.SqlServer.Dts.Tasks;

namespace PROFILE

{

class Program

{

static void Main(string[] args)

{

  Application app = new Application();

  string a;

  Package p;

  TaskHost t;

  p = new Package();

  p = app.LoadPackage("C:\\Visual Studio 2005\\PROFILE.dtsx", null);

  for (int i = 0; i < p.Executables.Count; i++)

  {
    Console.WriteLine("Component : " + p.Executables[i].ToString() );

    //Console.WriteLine(i);

    a = p.Executables[i].GetType().ToString();

    Console.WriteLine(p.Executables[i].GetType());

  }

  Console.ReadKey();    
}
}

}

reference link below Reference

SSIS - Referencing This Package in Script

Follow this question

Related Questions