SQL Server 2000 ActiveX Transformation.
Here we'll show you the ActiveX transformation screen in SQL Server 2000.
Figure 1.6 ActiveX Transform in SQL Server 2000.
Even a cursory glance tells us that this screen is hugely different. Again Microsoft have brought all the objects such as Global Variables and Lookups
down into the left hand sidebar which is brilliant because then you don't need to remember everything you can look in the list instead. They've
added a few buttons for us to play with like the Undo button which does what you think. One warning though don't keep pressing it otherwise everything
ActiveX scripting in a transformation or a task is often billed as something more difficult than it needs to be. Hopefully we've expliained the interfaces to you so that when you do come to use them at least you're not looking at the screen for the first time.