I'm trying to return the column names of my query results. In ADO, I can
simply do this:

objResults.Fields[1].Name

That code throws an error in an ActiveX Script Task.

I'm really new at using DTS, so there might be an easy solution that I'm
overlooking. (I hope!) :-)

Thanks in Advance,
Rich

Hi,

try objresults.Fields(1).Name

kind regards,
Richard

----- RB wrote: -----

I'm trying to return the column names of my query results. In ADO, I can
simply do this:

objResults.Fields[1].Name

That code throws an error in an ActiveX Script Task.

I'm really new at using DTS, so there might be an easy solution that I'm
overlooking. (I hope!) :-)

Thanks in Advance,
Rich

What is the error? What scripting language are you using

Russel Loski, MCSD