I need to import Data from a ‘Progress’ db to SQL2000 db.
In SQL, I have set up a local DTS package ‘Progress_Data’ which links a ‘Progress’ database to SQL2000.
If I right click the local package and select ‘All Tasks’, then ‘Import Data’, the ‘DTS Import/Export Wizard’ window appears.
I select the destination driver as ‘DataDirect 4.10 32-Bit Progress SQL92v9.1E’, then choose ‘File DSN’ to locate the .DSN and enter the UserName and Passwords. The next screen allows the selection of the local database (‘CRM_Mark’).
Once the above steps have been completed, a further selection can be made, allowing a query build or a selection of tables and views.
Although I can see the relivant tables, I cannot import the data as the following MS error messages are displayed:
1. If ‘Query’ selected:
‘Unexpected error message.’
2. If ‘Table/Views’ selected:
‘Unexpected error occurred: The provider has returned an error result without an error message.’
Any ideas? This is confusing as the connection has already been made in the DTS package and I can see the tables.
Thanks in advance,
Tom