How to execute an SSIS package from .NET?

by

Here is how to set variables in the package from code – 

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");
    }

More Related Contents:

  1. Determine if a number can be made with prepicked numbers and times
  2. When should I use a List vs a LinkedList
  3. Controlling Volume Mixer
  4. Difference in months between two dates
  5. How does inheritance work for Attributes?
  6. Inconsistency in divide-by-zero behavior between different value types
  7. Bulk Update in C#
  8. What is a predicate in c#? [duplicate]
  9. Winforms: Application.Exit vs Environment.Exit vs Form.Close
  10. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  11. EF 6 – How to correctly perform parallel queries
  12. The State of Linkers for .NET apps (aka “Please Sir, May I have a Linker” 2009 edition)
  13. Get the SourceControl of a DropDownMenu
  14. How to keep single SQL Server connection instance open for multiple request in C#?
  15. Received an invalid column length from the bcp client for colid 6
  16. Compare compiled .NET assemblies?
  17. How to Start a Process Unelevated
  18. Can a PictureBox show animated GIF in Windows Application?
  19. Failed to update .mdf database because the database is read-only (Windows application)
  20. .NET graph library around? [closed]
  21. center MessageBox in parent form [duplicate]
  22. How do you disable an item in listview control in .net 3.5
  23. GO statements blowing up sql execution in .NET
  24. Know when to retry or fail when calling SQL Server from C#?
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. How does the “Using” statement translate from C# to VB?
  27. How to insert a Symbol (Pound, Euro, Copyright) into a Textbox
  28. Generating sql code programmatically
  29. Objects implicitly instantiated in vb.net?
  30. How do I make a form modal in Windows Forms?

Leave a Comment