HI, I created a package that contains an ActiveX task and I would like
to get SQL server source column names in order to build datapump source
and destination column collections. Can I use an Execute SQL Task with
this query:


SELECT COLUMN_NAME FROM information_schema.columns WHERE table_name = ?

The parameter would come from a global variable. Now, how can I
reference the columns retrieved with the above query into my subsequent
ActiveX Script task? Worst case, I could use ADO to execute the same
query into the activeX script. If so, how can I connect an ADO
recordset using package connections?

Thank you,
Ccote