Post reply

SQLBase import error into MS SQL Server using DTS

  • February 19, 2003 at 9:32 pm

    #105440

    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

  • February 20, 2003 at 4:46 pm

    #449438

    Using the ODBC connection that you created, can you query the data in SQLBase and see what fields are returned?

    You might be getting an extra field on either side of the transformation.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • March 3, 2003 at 4:00 pm

    #450176

    Hi

    Yes, I can see the data through the DTS preview and in SQLBase, yet nothing looks unusual.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply