Hi,

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,


Neal

A Northern Soul

__________________
Neal

A Northern Soul