Execute SQL Server 2005 Integration Services package from C#

Introduction

There are many ways to execute a SQL Server 2005 Integration Services (SSIS) package.  You can use the command line utility DTExec.exe or its window equivalent, DTExecUI.exe. A package can be executed within SQL Server Business Intelligence Studio (Visual Studio) or from a SQL Server Agent Job Step. A package can also be executed from .NET code!

Example SSIS Package

For the purposes of demonstration, I created a simple package that takes some data out of a SQL Server AdventureWorks database and dumps it into a flatfile. The package also has one variable.

In any kind of "real world" scenario, your package will usually be driven by a configuration file.  An SSIS configuration file is an XML file with a.dtsConfig extension that contains settings you can apply to a package (without actually changing or editing the package).

SSIS::::Using Conditional Split Transformation

Introduction

   Create a New Project with the name as ExpressionLanguageDemo.Once the project is created, open Solution Explorer and rename Package.dtsx - change the name to ConditionalSplit.dtsx. If you've already created the project, right-click the SSIS Packages folder in Solution Explorer and

SSIS::::Solved BUG of Aggregation Transformation

         One day I was strucked with a bug when I am practicing Aggregate Transformation. After a day of frustration I searched for solution which rescue me. I think that every SSIS developer (and maybe every developer) can learn a thing or two from their mistakes.

SSIS::::Using Audit Transformation

About Audit Transformation::

    The Audit Transformation is a simple component that simply adds the values of certain System Variables as new columns as you name to the data flow. It looks like as below:

SSIS::::Using Aggregate Transformation

About Aggregate Transformation:

The Aggregate Transformation provides a means of carrying out some simple aggregations on data selected through source.Available aggregation functions in this transformation are:

creating an ssis package in BIDS

Creating a Package:

The Import and Export Wizard is easy to use, but it only taps a small part of the functionality of SSIS. To really appreciate the full power of SSIS, you’ll need to use BIDS to build an SSIS package. A package is a collection of SSIS objects including:

Brief Introduction to SSIS

SQL Server Integration Services (Introduction)

         SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. Extract, Transform and Load data.  While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just DW; e.g. when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created. At a high level,