You can manage SSAS objects using AMO and SSIS which enables you to have detailed control of SSAS Administrative tasks.  Read more...

This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

New author Jack Corbett brings us a look at a way of finding out what caused your error in Integration Services.  Read more...

An article that speaks about some of the issues faced by the Author, during his Data Integration Project using SSIS. Shared with you in this article are the issues he was faced with and the solutions applied.  Read more...

Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data.  Read more...

Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler.  Read more...

This article demonstrates how to extract, transform and load free-form data into a structured form like a staging table by way of XML conversions.  Read more...

This paper describes the Fuzzy Lookup and Fuzzy Grouping transformations that are part of SQL Server 2005 Integration Services (SSIS). These SSIS transformations are useful for improving the data quality of existing data as well as new data that is being loaded into your database.  Read more...

The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.   Read more...

The Trash Destination is now available for SQL Server 2005 and SQL Server 2008. The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement.  Read more...

This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.   Read more...

Expressions can be used to dynamically build an output file. Here we will show you another way to do this using the script task.  Read more...

In this article Dinesh Asanka demonstrates how you can use your own data sources in SQL Server Integration Services.  Read more...

Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.  Read more...

Describes different uses of the SSIS Foreach Loop container in one practical scenario.  Read more...

In this article Dinesh Priyankara explains how Checkpoint files can be used in a SSIS package so that the package can be restarted from the point of failure.  Read more...

Integration Services allows you to import all kinds of data easily into SQL Server as well as transform is along the way. Longtime author Paul Ibison brings us a look at how you should set your transformations to deal with NULL values.  Read more...

Microsoft MVP Andy Leonard brings us a great introduction to a common task for all DBAs: importing data.  Read more...

Use the power of regular expressions to cleanse your data right there inside the Data Flow. This transformation includes a full user interface for simple configuration, as well as advanced features such as error output configuration.  Read more...

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...

New author Jack Corbett brings us a look at a way of finding out what caused your error in Integration Services.  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...