arooj300 (8/27/2014)
2)In connection tab, Oledb connection manager- Destination server, use a table or a view- table name
Write a query instead. Retrieve only the columns you actually need to do the lookup.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP