I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008! The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! They're sold out again. Great job! :{> Andy

I had a fantastic time presenting Change Data Capture, Incremental Loads, and SSIS 2008 to the Minnesota SQL Server User Group tonight! They're a fun bunch. It was cool to meet Lara and Mark in person - and thanks Lara for bailing me out on a couple relational engine questions! (I am such a developer sometimes...) :{> Andy

Background  I'm working on an SSIS package that FTPs files from heterogeneous sources to Windows servers. I currently have three types of servers in the mix: Windows, Unix, and iSeries. When I first started this phase of the project, I tested the SSIS FTP Task and it worked well... on two out of three.  Durnit. Hope Floats (or at ...

Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task. The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say ''statistics'' I mean things like column value and length distribution, column null ratio, column patterns, and functional dependencies. You ...

Introduction  On Thursday, 24 Jan 2008, I presented New Features In SSIS 2008 to the Richmond SQL Server Users Group. Most of the presentation was dedicated to demonstrating Change Data Capture (CDC) interacting with SQL Server 2008 Integration Services. I started seriously working on this demo the first week of January, thinking ...

According to numerous sources - most recently a SQL Server Magazine article entitled Too Soon for SQL Server 2008? Readers Say ''Yes!'' - a lot of SQL Server customers are holding off upgrading to SQL Server 2005, preferring to wait for the upcoming release of SQL Server 2008. While I understand the economics, I worry about the ...

Here is an update of what I accomplished in the first 20 days   Read the book lifehacker Read the book Microsoft SQL Server 2005 Integration Services Read the book  Extending SSIS 2005 with Script Read 1 chapter of Learning Python, Second Edition Played around with the July CTP of SQL Server 2008   So in the first 20 days ...

Where do I send a thank you letter? Finally we are allowed to use C# in the SQL Server Integration Services Script Task. I always wondered why SQL Server 2005 only uses VB and not C#, you can use C# in the SQLCLR but not in a Script Task. It turns out that SSIS in SQL Server 2005 uses VSA (Visual Studio for Applications) but SQL Server 2008 will ...