SQL Server Performance Forum – Threads Archive

DTS Question.

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.

---

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

---

]]>