Learning ActiveX
-
What's a good method to learn ActiveX, as used in DTS packages ?
-
Trial and error, walking around like a blind man in a dark room, is the way I did it. Not recommended though
The absence of evidence is not evidence of absence.
Martin ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel -
1) Choose VBScript or Java script. Everyone I know outside an institution chose VB...
2) Either:
a) buy a VBScript book, or
b) read VB tutorials on the web and ignore 80% of the good practices, or
c) get the laziest programmer you know to help
VBScript is very like classic VB but with even more for C++ people to sneer at (no variable typing, rotten error handling, you can write code that works within a short time, a lot less of a learning curve, sensible terms (whaddaya mean a void is some code and not some empty space?), blah, blah).
AFAIK, the main local knowledge you need for DTS ActiveX scripting is to set the return value of the Main function to one of the success or failure constants to help the package workflow, and that most properties of the package itself and its components (eg global variables, connection data, etc) are accessible.
The MSDN docs start at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vbscripttoc.asp
-
A quick listing of all commands available, allong with short examples can be found at: http://www.devguru.com under the vbScript heading.
Browse through all the commands of interest and hack away for a little bit... Learn from reading and understanding other peoples code... on this site as well as sqldts.com, etc...
-Mike Gercevich
-
I have found http://www.sqldts.com/default.aspx to be very useful when I need to get something done in DTS. Plus a general familiarity with VB/vbsript technologies.
-Ed Zann
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply