With the Data Transformation Services (DTS) Lookup object, you can retrieve data from locations other than the immediate source. A query and a connection is associated with the lookup. If the query returns more than a single column, the Lookup object returns the results in a zero-based array.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help