How do you iInclude the ADO Enumerated Constants?

[devRyan]

Hi all,

I'm working on a script in DTS in which I need access to the ADO Enumerated Constants Library, and can't figure out how to reference it.

My background is mainly in programming in ASP, where this is done eitehr via #including an ADOVBS.inc file, or via use of a META tag. The latter being prefered, of course.

I've been doing some reading up on the more modern ways of vbscripting using the WSF format(ie; <job><reference...><script>..etal, which seems like a wonderful way of doing things, but apparently SQL Server 2000 doesn't agree and fails when I try to use the WSF format.

Basically, all it(SQL2000) will accept is what I've found to be termed as "naked vbs", and in such can't figure out how to include the ADO constants library.

Sure, I could just use the numeric equivalents, but don't really want to, since even MS advises against it in case they change the values in subsequent verions.

Does anyone know how this is accomplished?

Thanks,

Ryan