Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS vbscript - choosing column

Author  Topic  pitt1 Starting Member 16 Posts Posted - 2006-04-18 : 03:31:27 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