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.
Source= Progress 9.1
odbc= Openlink Generic 32 Bit Driver
destination=SQL Server 2000