Type Mismatch: DTSLookups?
- From: "Dave" <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Apr 2005 18:21:03 -0700
I have Transform Data Task that I want to Lookup some company values from
another database based on a code from the source and insert them into the
destination
Under the Transform, Workflow Properties, Options, Use ActiveX script
checkbox I have my code to call the Lookup below, but I keep getting the type
mismatch error. I even commented out everything and tried to set the
destination to a dummy string but still get type mismatch.
Is this the correct place to put the ActiveX Script during the transform? I
would really like a good step-by-step guide of how to do this. Thanks, Dave.
Function Main()
dim varArray
varArray = DTSLookups("GetCompanyValues").Execute(DTSSource("CoId").Value)
DTSDestination("Ticker") = varArray(0)
DTSDestination("Region") = varArray(1)
Main = DTSStepScriptResult_ExecuteTask
End Function
.
- Follow-Ups:
- Re: Type Mismatch: DTSLookups?
- From: Allan Mitchell
- Re: Type Mismatch: DTSLookups?
- Prev by Date: Re: sql server agent job step that runs a dts package fails - urge
- Next by Date: importing files using dts
- Previous by thread: Numeric Overflow of Column of datatype Money
- Next by thread: Re: Type Mismatch: DTSLookups?
- Index(es):
Relevant Pages
|
