We are working with a healthcare billing application called Medisoft. Currently we are using MedStar but we are converting to Medisoft. I am attempting to insert the Medstar (MS SQL) into Medisoft (Advantage Database by Sybase). I have setup ODBC drivers and I can access both databases with out issues using anything (Crystalrepts, SQL2k Entmgr, Excel,..). I went into MSSQL2000 Enterprise Manager and setup a DTS transaction to transform the require columns/tables from one database to the other, when I innitaite the transaction if fails with the error below.
It states there is an error in the SQL statement but I have no where to edit the INSERT INTO SQL statement, only the SELECT FROM statement. We are trying to convert several tables and close to 200 columns across the tables which is why I am posting here to see if anyone knows a way around this ... or has any suggestions. This is the error that I am tossed from MS SQL 2000 Ent MGR when attempting to run the Data import or export wizard from MSSQL2000 to AdvantageDatabase VIA ODBC or OLEDB drivers.
___________________
The number of failing rows exceeds the maximum specified.
[Extended Systems][Advantage SQL][ASA] ERROR 7200: AQE Error: State = 42000; NativeError = 2115;
[Extended Systems][Advantage SQL Engine]Expected lexical element not oufnd:) You are missing the closing ")" after the column identifiers in INSERT INTO. --Location of error in the SQL statement is :27
___________________
Thank you.
Start Free Trial
