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.