Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
A Tour Of ActiveX
By Allan Mitchell
Version 7.0/2000
Level Beginner
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6

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.

AXTform2000

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 disappears.

Conclusion

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.

Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6