SQL Server Performance

DTS Question.

Discussion in 'SQL Server DTS-Related Questions' started by kannanonline, Jan 28, 2004.

  1. kannanonline New Member

    I'm building a DTS which takes values from text file (source) and outputs an execel file (destination).
    I wanted to display multiple values in a single column..

    for eg:i tried (in activeXscript)

    Dim arr(1)
    arr(0)="1"
    arr(1)="2"

    for i = 0 to 1
    DTSDestination("number")=arr(i)
    next
    Main = DTSTransformStat_OK

    after giving this i get the output with last array value in all rows of the column

    Any help will be appreciated.
  2. cnu77 New Member

    Hi,
    Try this...
    for i = 0 to 1
    DTSDestination("number")=DTSDestination("number") & cstr(arr(i))
    next
    Seenu

Share This Page