I am trying to create a DTS package that will run every night to copy data out of a Centura/Gupta SQLBase database into a MS SQL Server database.
I have downloaded and installed all the latest ODBC drivers for SQLBase and MDAC.
I use the MS SQL Server DTS Wizzard to make the ODBC connections, create and copy the data. Checking the Preview shows that there is data in the table that I am copying (only testing on one table at a time). The SQL Server creates the table with the correct table names and then tries to copy data. This is were it all falls over in a heap.
The pop-up title bar says "Copy Data from 'abc' to 'def' Step". I get an error that says "Column name 'xxx' was not found.".
I have a long winded workaround of unloading the data into an ascii file from the SQLBase database and then using DTS to load the data into SQL Server. This works but is not the prefered method.
Any help would be greatly appreciated.
Thanks
I have downloaded and installed all the latest ODBC drivers for SQLBase and MDAC.
I use the MS SQL Server DTS Wizzard to make the ODBC connections, create and copy the data. Checking the Preview shows that there is data in the table that I am copying (only testing on one table at a time). The SQL Server creates the table with the correct table names and then tries to copy data. This is were it all falls over in a heap.
The pop-up title bar says "Copy Data from 'abc' to 'def' Step". I get an error that says "Column name 'xxx' was not found.".
I have a long winded workaround of unloading the data into an ascii file from the SQLBase database and then using DTS to load the data into SQL Server. This works but is not the prefered method.
Any help would be greatly appreciated.
Thanks
