Bad data import

Capturing Real-Time Currency Conversions in SSIS

Integration excels at moving and transforming data in real time. Jeff Singleton brings us a great use of SSIS in making currency conversions using a web service.

Consolidating SQL Server Error Logs from Multiple Instances Using SSIS

SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.

How to Read Excel Cells from SQL Server Integration Services

We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.

SSIS for Multiple Environments

In this article, Zach Mattson shows us how you can set up SSIS to handle multiple application environments and easily move packages from development to QA to production.

Hello SSIS World, From XML!

This article brings us an SSIS package that reads an XML file and sequentially displays each XML record in a MessageBox before inserting it into a staging table. You can use this to get XML data into your SQL Server database for further processing.

New and Improved Functionality in SSIS 2008

While it does not bring revolutionary changes, the release of SQL Server 2008 delivers functionality, scalability, and performance improvements to SQL Server Integration Services (SSIS). Here is a comprehensive listing of new and enhanced features of SSIS with a short description of each.

Run an SSIS Package Under a Different Account

In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.

Microsoft SQL Server 2008 Integration Services Problem-Design-Solution - Sample Chapter

Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.

SSIS Packages - the Simplest Way to Create Them

Martin Policht delves deeper into the specifics of SQL Server 2008 and 2008 R2's Integration Services by presenting the most straightforward method of creating SSIS packages using Import and Export Wizard.