How to execute an SSIS package from .NET?

Question

I have a SSIS kit that I want to transfer parameters too, these parameters must come from a. NET framework (VB or C #) so I was wondering if anyone knows how to do this, or better yet a website with helpful tips on how to do this.

So essentially I want to run a SSIS package from. NET that transfers the parameters of the SSIS package it can use inside.

For example, the SSIS package will use flat file importing into a SQL database but the file name and path might be the parameter passed from the. Net application.

Answer 1

Here's how to set variables from code within the package 

using Microsoft.SqlServer.Dts.Runtime;

private void Execute_Package()

    {           

        string pkgLocation = @"c:\test.dtsx";

        Package pkg;

        Application app;

        DTSExecResult pkgResults;

        Variables vars;

        app = new Application();

        pkg = app.LoadPackage(pkgLocation, null);

        vars = pkg.Variables;

        vars["A_Variable"].Value = "Some value";               

        pkgResults = pkg.Execute(null, vars, null, null, null);

        if (pkgResults == DTSExecResult.Success)

            Console.WriteLine("Package ran successfully");

        else

            Console.WriteLine("Package failed");

    }

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.