Google Anlatics

Sunday, August 14, 2011

SSIS simple way to start

SSIS – simple way to start
These are the link you can find for easy way to start SSIS.
http://msdn.microsoft.com/en-us/library/ms170419.aspx
http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm
http://www.mssqltips.com/tutorial.asp?tutorial=200

How to Run a Package SQL Server 2008 R2

To run an Integration Services package, you can use one of the following tools:
• The dtexec command prompt utility (dtexec.exe).
• The Execute Package Utility (dtexecui.exe).
• A SQL Server Agent job.

http://msdn.microsoft.com/en-us/library/ms138023.aspx

Running an SSIS Package Programmatically on the Local Computer SQL Server 2008 R2
With only a few lines of managed code and the correct prerequisites on the local computer, you can run a package from a custom application. The custom application can be a Windows Forms application, a console application, an ASP.NET Web form or Web service, or a Windows service.

http://msdn.microsoft.com/en-us/library/ms136090.aspx#Y1954

I think this code will be useful
This can be run creating console application.

using System;
using Microsoft.SqlServer.Dts.Runtime;

namespace RunFromClientAppCS
{
  class Program
  {
    static void Main(string[] args)
    {
      string pkgLocation;
      Package pkg;
      Application app;
      DTSExecResult pkgResults; 

      pkgLocation =

        @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services" +

        @"\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";

      app = new Application();
      pkg = app.LoadPackage(pkgLocation, null);
      pkgResults = pkg.Execute();

      Console.WriteLine(pkgResults.ToString());
      Console.ReadKey();
    }
  }
}
Sri Lanka .NET 
                Forum Member