How to use a Script Transformation in SSIS

This shows you how to use the Script Transform to make intelligent decisions about your data and clean it appropriately.

Downloading a file over HTTP using SSIS

A question came up on an internal alias about how can one download a file over HTTP. Here's a script that does that, should be trivial to wrap it inside a task if you forsee doing this over and over again.

SQL Server Integration Services - Debugging Script Componen

Continuing the coverage of debugging features in SQL Server 2005 Integration Services Data Flow, which we started in the previous installment of this series, we will now focus on the Script Component.

Creating an End-to-End Package

In this sample chapter, you'll get a full tutorial on how to create an end-to-end SSIS package including transformation, looping and archiving of files.

Upgrading SQL Server 2000 DTS Packages to SSIS

If you're like Brian Knight, you probably have dozens if not hundreds of DTS packages running around that you're terrified to touch. SQL Server 2005 has some interesting methods to upgrade your packages to SSIS with minimal effort. This article shows you a few ways that you can use to upgrade and some of the drawbacks.

SQL Server 2005 Integration Services, Part 2: Developing Custom Compon

The first phase of Project REAL included the migration of existing SQL Server 2000 DTS packages to SQL Server 2005 Integration Services (SSIS) for a large electronic retailer. One source of information for the data warehouse was from TLog files, which contained data from point-of-sale cash registers in stores. TLog files store data in packed decimal format. To extract and transform this data into a format suitable for loading into the relational data warehouse tables, it was necessary to unpack and parse the files. To achieve this, custom pipeline components were implemented to read and transform the data by extending the SSIS object model. This paper discusses what we learned while implementing the pipeline components for extracting and parsing data from the TLog parser

SSIS Packages are Encrypted by Default

By default, SSIS files in development are encypted to prevent an unauthorized person from seeing your SSIS package. The type of encyrption is seamless behind the scene and is at a workstation and user level. So, if you were to send a package that you're developing to another developer on your team, he would not be able to open it by default. This shows you how to fix this problem.

Which of these is not a configuration type...

DTS to SSIS Migration

Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating a DTS-to-SSIS migration strategy.

An Elegant ETL Solution: Except for Lost Data

An early adopter of SQL Server 2005 found some issues with Integration Services. And he shows how it was debugged and the issue solved. This is a great look at some of the helpful parts of Intration Services in solving problems as well as a few places it falls short.