In a SSIS data flow, there are multiple types of transformations. On one hand you have synchronous and asynchronous transformations, but on the other hand you have non-blocking, semi-blocking and fully-blocking components. In this tip, Koen Verbeeck takes a closer look on the performance impact of semi-blocking transformations in SSIS.
Read more...

This article demonstrates how to create a CLR assembly that can encrypt or decrypt a file with AES-256 cryptography, how to reference the CLR assembly from an SSIS script task, and how to generate an MD5 checksum file so that its recipient can confirm the integrity of the encrypted file.
Read more...

In this tip we have a very simple data flow using a source query with a predictable duration. The data flow takes longer to process all the rows and even larger buffers didn't make the problem go away. What can be the cause of this and how do we solve this? Koen Verbeeck explains.
Read more...

SQL Server Integration Services does not provide native SFTP, encryption or archiving task components. This article presents a set of open source custom task components that provides these functions.
Read more...

Integration Services can be used to load data from a number of source files stored in different folders. This next level in the Stairway Series for Integration Services shows exactly how you can use parameters, variables and the ForEach Loop Container to do this.
Read more...

A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.
Read more...

Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).
Read more...

If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of databases, and you want to be alerted about a number of diverse events that are useful for first-line problem-diagnosis and auditing, then Feodor's homebrew solution, using SSIS and Robocopy is likely to be what you're looking for.
Read more...

Excel spreadsheets are useful for distributing data generated by SQL Server, but SSIS lacks direct support for writing Excel files. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.
Read more...