I am trying to use a DTS package to extract data from an old Pervasive SQL
2000 (Btrieve) data source, and copy into an MS SQL Server table.

I have installed the Pervasive ODBC driver and got linked tables in Access
working. I can see the data.

When I create the DTS package, it shows a list of the tables in the
drop-down, but when I hit the Preview button I get an unspecified error. I
can finish setting up the DTS package, the new MS SQL Sever table gets
created, and the field transformations all look correct. However, when I
execute the package it fails. In the logs, I get an unspecified error, the
only error code I get in log is: 80074005.

Please help.

Thanks!


--
Carson