Hi,

I need help in creating a DTS package. I have an excel spreadsheet that
has a column of employee ids. i need to connect to an oracle database,
pull employee information based on teh employee id and then dump it in
sql server database.

Does anyone have any suggestions on how to accomplish this,

Thanks
Mohan

Hello Mohan,

In DTS this is never going to be too pretty. You have number of options
though

Make the Excel spreadsheet and Oracle server, linked servers from EM and
use OPENQUERY to get the data.

Transfer the data from the XL Spreadsheet to the oracle server and then issue
a query against the oracle server.


There are more ways but I know of none that are particularly appealing.

Allan