Exploring packages in code

This post builds on some of the previous code and shows how you can explore all objects inside a package. I took the sample Task Search application I’d written previously, and came up with a totally pointless little console application that just walks through the package and writes out the basic type and name of every object it finds, starting with the package itself e.g. Package – MyPackage .

Downloading a file over HTTP the SSIS way

This post shows you how to download files from a web site whilst really making the most of the SSIS objects that are available. There is no task to do this, so we have to use the Script Task and some simple VB.NET or C# (if you have SQL Server 2008) code

Transfer Logins Task and Transfer Database Task in SSIS

The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.

Different ways to execute an SSIS package

In SQL Server 2005 and higher versions there are different ways in which one can execute an SSIS package. Let us go through each option one by one.

Execute SQL and Bulk Insert Tasks in SSIS

Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.

Logging connection strings

If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing.

Creating packages in code – Execute SQL Task

The Execute SQL Task is for obvious reasons very well used, so I thought if you are building packages in code the chances are you will be using it. Using the task basic features of the task are quite straightforward, add the task and set some properties, just like any other. When you start interacti.

SSIS multi-environment configuration in a single SQL Server table

Centralize SSIS configuration for multiple environments into one table.

We Loaded 1 Terabyte in 30 Minutes with SSIS, and So Can You

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.

SSIS Package Execution