data import source = odbc link destination=sql server 2k with stored procedure -- sql server programming

Lenny
8/5/2003 6:40:10 PM

Try using openrowset function.
SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={whatever ODBC driver};SERVER=serverName;UID=id;PWD=password',
'select * from dbName.ownerName.tableName) AS a

ODBC should map provider data type to SQL Server types.

[quoted text, click to view]

Gazi
8/5/2003 11:40:51 PM

Hi,

I want to import data from an odbc linked database. The source database is
progress, linked with the Openlink Odbc connection. If i use DTS, i get
(known) problems because there is a memo field in the source table. Here it
was recommended to use a stored procedure instead of a DTS.

As i am a newby with sql server, i don't know how. Could someone please help
me with this. Examples and so are welcome.

Thanx

Gazi

Information:
Source= Progress 9.1
odbc= Openlink Generic 32 Bit Driver
destination=SQL Server 2000

sql server programming : data import source = odbc link destination=sql server 2k with stored procedure