Welcome to MSDN Blogs Sign in | Join | Help

August 2008 - Posts

Friday, August 22, 2008 4:17 PM

Enum value for Lookup’s NoMatchBehavior property

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”.
Posted by mmasson | 0 Comments
Filed under:
Friday, August 22, 2008 4:05 PM

Accessing OLEDB Connection Managers in a Script

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
Posted by mmasson | 2 Comments
Tuesday, August 19, 2008 4:03 PM

Competitive Comparison of SQL Server 2008 Integration Services

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
Posted by mmasson | 2 Comments
Filed under:
Tuesday, August 19, 2008 9:56 AM

New SSIS community samples

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
Posted by mmasson | 2 Comments
Filed under:
Wednesday, August 06, 2008 11:09 AM

SQL Server 2008 RTM is Live

The RTM version of SQL Server 2008 is now available for MSDN and Technet subscribers. Hurray!
Posted by mmasson | 2 Comments
Filed under:
 
Page view tracker