Possible to select multiple fields in a Lookup?

[rodeomount]

Is it possible to run a select statement to return more than one field in a select statement inside a dtsLookUp?


Ex place the following statement in a Lookup

Select Field1,Field2 from TableA where something = ?

 

[fuzzyocelot]

I believe so. Try something like the following code as a VB Script within an ActiveX Script transformation:

	Dim i, myResult, strSomething
	
	strSomething = "Y"
	i = 0
	myResult = DTSLookups("Query_TableA").Execute(strSomething)
	If IsEmpty(myResult)= False Then
		For i=0 to 2
		   	If trim(myResult(i)) = "X" Then
			       Exit For
		   	End If
		Next		
		i = i + 1
	End If

Hope it helps!