The lookup transform has a new property in SQL 2008 which controls how to handle rows with no matches – NoMatchBehavior. It has two values - “Treat rows with no matching entries as errors” and “Send rows with no matching entries to the no match output...

Accessing ADO.Net Connection Managers from an SSIS script task / script component is pretty easy – you just need to cast the object returned from AcquireConnection() to the appropriate class (i.e. SqlConnection if you’re using SQL Native Client). SqlConnection...

Did you know about this white paper comparing SSIS to IBM Information Server (DataStage), Informatica PowerCenter, Oracle Warehouse Builder, and Oracle Data Integrator? I had heard rumors of its existence, but I hadn’t actually seen the links for it until...

Some new samples have been added to the SSIS community samples project on codeplex . Delimited Flat File Reader This data flow source component is capable of parsing delimited flat files, including files with rows that are missing columns. Package Generation...

The RTM version of SQL Server 2008 is now available for MSDN and Technet subscribers. Hurray!