Sql Server Integration Services

I have done a lot of ETL over the years.. a lot of DTS automation.

When I opened the bright, shiny package called SQL 2005.. I fully expected to be able to create a DTS package with a wizard, and then SAVE THE PACKAGE AS A VBS.

That used to work, it used to work beautifully.

Fast forward to SQL 2005.. Now, Sql Server offers a tool with BETTER OPTIONS, and more complexity.

I have seen crazy SSIS implementations with tons of inheritance and re-use.  I think that is slightly more work than it needs to be.. but it’s incredibly powerful.

Now, with SQL 2012, they finally gave us UNDO AND REDO.

I feel so lucky to finally have more capable tools than what we had 12 years ago.