Good morning-

I am trying to accomplish the following. In my lookup,
I need to find a value in a column(Store) when either the
Store_Code or Store_Code_Orig column value match the
variable passed through the lookup. I have this and it
works for one:


SELECT STORE
FROM K_Collect_Code
WHERE (Store_Code = ?)

but I need to have it use the Store_Code_Orig column as
well. Here is the transform incase that helps.

Function Main()
dim CM_ID
dim Store_Code
Store_Code = (DTSLookups("Store_Code").Execute
(DTSSource("Col018").Value))
CM_ID = Store_Code + DTSSource("Col009")
DTSDestination("CM_ID") = CM_ID
Main = DTSTransformStat_OK
End Function

Thanks for any help!!

In message <bff701c489df$96bf7aa0$a501280a (AT) phx (DOT) gbl>, jyork
<anonymous (AT) discussions (DOT) microsoft.com> writes
Try-

SELECT STORE
FROM K_Collect_Code
WHERE (Store_Code = ? OR Store_Code_Orig = ?)


Function Main()
dim CM_ID
dim Store_Code
Store_Code = DTSLookups("Store_Code").Execute
(DTSSource("Col018").Value, DTSSource("???").Value)
CM_ID = Store_Code + DTSSource("Col009")
DTSDestination("CM_ID") = CM_ID
Main = DTSTransformStat_OK
End Function



http://www.databasejournal.com/featu...le.php/1459171

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org