Connecting to an external table from a stored procedure

[rushdib]

Hi,
I would like to whether it is possible to write a stored procedure to extract data from an external source. (using an ODBC connecting string). I know I can use DTS, but I have to massage the data before I move it into a SQL Server table and I have to use functions to modify the data.

Thanks,

Rushdi Basir

 

[JohnDTampaBay]

Check out OPENDATASOURCE and OPENROWSET in BOL.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.