vbscript in a dts 1

[clyde11]

Hi all,

I'm writing a DTS activeX with VBscript and
would like to access a data in in an excel sheet
on the first row, while using

DTSDestination("columnA") = DTSSource("columnB")

will assign "columnB" in "columnA" for each row,
how do I do this for specific row source column
(for example assigning "columnB" row 1, into "columnA")

Best,
Ahron

 

[markdmac]

on error resume next
set x = getobject(,"excel.application")
x.cells(1, 1).value = x.cells(1, 2).value

I hope you find this post helpful.

Regards,

Mark