Guide to MCITP: SQL Server 2008 BI Developer

A guide to the SQL Server 2008 Business Intelligence exams.

SSIS 2012 - Catalog Encryption

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters, converting packages to the project deployment model, updating Execute Package tasks to use project references and parameterizing the PackageName property.

SSIS 2012 - Parameter Precedence

Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.

SSIS-Fast Parse

SSIS-Cache Transform

SQL Server Integration Services - Delay Validation

Using delay validation the designer can control the response of default behaviour of package validation which happens at design time and also at run time.

Exploring SSIS Architecture and Execution History Through Scripting

When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.

Using SSIS to Maintain the File System

Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.