I am using DTS sql 7
How can I pass parameters using the lookups in DTS to access oracle database?
i know in sql u could do e.g
select company_ID from Company
where
Company_Desc = ?
but it won't work with oracle.
i have used
select company_ID from Company
where
Company_Desc = '&company_desc'
but it did not ask for a parameter.