Running the SSIS package from Console/Windows/Web Application

The running SSIS package in Console/Windows/Web Application needs of usage of namespace.

Microsoft.SqlServer.Dts.Runtime.

Go to Solution Explorer of your project?Rightclick and the references

Add reference-->add Microsoft.SqlServer.Dts.Runtime;

Then call the added namespace into your project.

Running the Package in a Console application you need to think in your mind.

Package ->As your running the SSIS package, create a object of package;

Package path ->Path of the package where you have stored.

Application->This object will create an Instance of application.

Package results->we use DTSExecResult this object available in Microsoft.SqlServer.Dts.Runtime which helps to know the the packet is excuted sucess fully or not.

using System;

using Microsoft.SqlServer.Dts.Runtime;

 namespace RunningSSISInConsoleApp
{
    class Program
    {
                         static void Main(string[] args)
      {
      string pkgLocation;
            Package pkg;
            Application app;
            DTSExecResult pkgResults;
pkgLocation = @"C:\Users\dell\Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\package2.dtsx";
            app =new Application();
            pkg = app.LoadPackage(pkgLocation, null);
            pkgResults = pkg.Execute();
            Console.WriteLine(pkgResults.ToString());
Console.ReadLine();
}

 }

}

Source :MSDN Microsoft