Browse by Tags

• Database Developer
• database developers
• Database Testing
• Design Pattern
• ETL
• quality
• SQL Server 2008

• SSIS Design Pattern - Collect Enterprise SQL Server Database Metadata With SSIS

  Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email. Read More... Posted Thursday, August 28, 2008 10:42 AM by andyleonard | 4 Comments Filed under: Design Pattern, SSIS, SQL Server

• New SSIS 101 Article

  My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Thursday, August 21, 2008 11:20 AM by andyleonard | 0 Comments Filed under: SSIS, Database Developer, SQL Server, ETL

• 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 Read More... Posted Wednesday, November 21, 2007 1:53 PM by andyleonard | 1 Comments Filed under: SSIS, quality, SQL Server, Database Testing, SQL Server 2008

• 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 Read More... Posted Tuesday, November 13, 2007 9:06 AM by andyleonard | 2 Comments Filed under: SSIS, SQL Server, database developers