Trying to set a destination column to a string variable

#1

Here is my transform. What I am trying to do is set a source column to a
string variable. I get an error -object required: String: "Tlowe"
I am not real great with VBS. Any help is appreciated. Thanks!

Function Main()

DIM MyVar
Set MyVar= "TLOEWE"

DTSDestination("Col004")=DTSSource("MyVar")

Main = DTSTransformStat_OK
End Function

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Trying to set a destination column to a string variable

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Trying to set a destination column to a string variable - 09-20-2004 , 11:55 AM