Re: Trying to set a destination column to a string variable

#1

Allan-

That is exactly what I was trying to do. It seems I was making it harder
than I needed to. I am still very new to this. Thanks!!!!!

"Allan Mitchell" wrote:

Quote:

In article <1C55822F-1425-48E9-A17E-9B3489EF0CB1 (AT) microsoft (DOT) com>, Jeff York
wrote:
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

So this value will be effectively a constant right ?

You cannot set a source column in an Active X transform.

Do you want to assign this to a destination?

DTSDestination("Column Name") = "Hello World"

I am not sure what exactly you want to do .

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

#2

In article <1C55822F-1425-48E9-A17E-9B3489EF0CB1 (AT) microsoft (DOT) com>, Jeff York
wrote:

Quote:

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

So this value will be effectively a constant right ?

You cannot set a source column in an Active X transform.

Do you want to assign this to a destination?

DTSDestination("Column Name") = "Hello World"

I am not sure what exactly you want to do .

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

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

Re: Trying to set a destination column to a string variable

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

Re: Trying to set a destination column to a string variable - 09-20-2004 , 01:21 PM

Re: Trying to set a destination column to a string variable - 09-20-2004 , 02:10 PM