Code Camp RDU Fall 2008 is tomorrow (15 Nov 2008)! If you're going to be in the Raleigh area tomorrow and are interested in anything related to Microsoft technology, register and check out the sessions. I always have a blast in Raleigh! I will be presenting my popular session: Incremental Loads, Change Data Capture, and SSIS 2008. Hope to ...

It's That Time of Year Again...  I am honored to again be presenting at the PASS Summit! I'm even more honored to be co-presenting SSIS Scripting with Jessica Moss, SQL Server MVP! Errata Somewhere in the abstract for this presentation I listed the following three goals: Explore SSIS Script Objects Best practices for script ...

Slides and demos for my hdc08omaha talks are now available for download from http://tinyurl.com/5oykgj Thanks to all who attended!

I finally get to meet Brian Kelley in person! I'll be presenting Incremental Loads, Change Data Capture, and SSIS 2008 to the Midlands PASS Chapter in Columbia, SC on Thursday 2 Oct 2008! If you're in the area and read this blog, stop by and say ''Hi''. :{> Andy

Hello, I am a developer with little knowledge of DTS packages and SSIS. I have stumbled across a problem with DTS packages that needs to be solved.... I have number of DTS packages that I do not want to migrate into SQL Server 2008. But what I DO want is to move the database the DTS packages connect to into SQL Server 2008. The DTS ...

Today I come into a nice bug (misfeature?) of SSIS 2008 and I'd like to share it with you. Let's start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce several outputs for new, deleted, updated rows and so on. It is the classical ...

I am honored to be selected to present at the 2008 PASS Summit! I'm presenting two sessions: Test-Driven Development For Database Professionals and SSIS Scripting. I've been working on the presentations recently and realize there will be a few minutes left in the SSIS Scripting talk unless I talk slow. (Some people say I talk slow enough ...

My friend Steve Fibich has published a small series on examining DTExec processes to determine which SSIS packages they're running. He uses WMI and PowerShell. Really cool stuff - check them out! dtexec.exe what are you doing? dtexec.exe what are you doing? (part II) :{> Andy

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. She had a few questions so I opened the package and began poking around some to answer ...

How are you doing the import?  Are you using SSIS, the Import Wizard, BULK INSERT, BCP..?  SSIS should be able to rip through this thing with no problem and if there are any problem rows you can redirect them to an error log and deal with them separately.