I have SQL Server 2000 on Windows NT server machine. In one of my DTS I have
to write an active X script to get some data from the database. How do we
connect to database and read a table in active X script?

Thanks

JY

You would use VBScript and ADO. What info do you want. You could use
Global Variable recordsets in an ExecuteSQL task seeing as you are using
2000

How to loop through a global variable Rowset
(http://www.sqldts.com/Default.aspx?298)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"J Y" <jy1970us (AT) hotmail (DOT) com> wrote