SSIS and Visual Studio 2008

Harper Trow of GenYSystems tells me he cannot open SSIS 2005 packages in Visual Studio 2008. I have not yet confirmed this personally but I trust Harper implicitly – he’s one of the smartest developers I know. More later… In a related story: there’s a download that allows you to interact with SQL Server 2008 CTP …
Continue reading SSIS and Visual Studio 2008

Skipping SQL Server 2005

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 DBAs …
Continue reading Skipping SQL Server 2005

SSIS Design Pattern – ETL Instrumentation, Part 3

Introduction  This post is part of a series of posts on ETL Instrumentation. In Part 1 we built a database to hold collected SSIS run time metrics and an SSIS package to deomnstrate how and why we would load metrics into the database. In Part 2 we expanded on our database and the SSIS package …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 3

SSIS Custom Tasks and Components Samples

You can find SSIS 2005 Custom Tasks and Component Samples at CodePlex. At the same location you can find SSIS 2008 samples. How cool is that? The samples include source code in VB.Net and C#. They serve as a decent starting place for developing your own SSIS custom tasks and components. Free registration to CodePlex …
Continue reading SSIS Custom Tasks and Components Samples