Advertisement

06.05.2008 at 08:34PM PDT, ID: 23462621
[x]
Attachment Details

Identify DTSSource using an index number ... possible?

Asked by gnoon in MS SQL DTS, dBase, Database

Tags: SQL 2000, dBASE5, VBScript

I have a dBase5 file data.dbf which able to be displayed by excel app as following

  FIELD1   FIELD2
  blah       blah
  blah       blah

Currently, I can run DTS successfully using field name as reference

DTSDestination("DEST_FIELD_NAME") = DTSSource("SOURCE_FIELD_NAME")

I would like to reference the field using index 0, 1, 2, 3, ...

DTSDestination("DEST_FIELD_NAME") = DTSSource(0)   for example

Is it possible?Start Free Trial
[+][-]06.07.2008 at 01:08AM PDT, ID: 21734661

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 07:56AM PDT, ID: 21779587

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 11:04AM PDT, ID: 21781317

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, dBase, Database
Tags: SQL 2000, dBASE5, VBScript
Sign Up Now!
Solution Provided By: AaronAbend
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.14.2008 at 08:40PM PDT, ID: 21787363

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_EXPERT_20070906