I could display rowset values one by one as follows. But How to hold the rowset values in an array of a global variable?

ie.
rowset = select a,b,c from tabl
Set oRS = DTSGlobalVariables("RSTables").Valu
msgbox oRS.Fields(0).Value '
msgbox oRS.Fields(1).Value '
msgbox oRS.Fields(2).Value '

You can't. If what you want is to have is something like this

SELECT A,B,C FROM TABLE

This returns > 1 row

Global Variable A
Global Variable B
Global Variable C

The Global Variable associated with the field name will hold an array of the
field.

Is that what you want ?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Janliz" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Yes. That's what I want.