Q
Problem solve Get help with specific problems with your technologies, process and projects.

Money data type conversion issue using DTS

leaving at I need to convert my Sybase data to MS SQL Server. I tried this using the following three methods for a single table. The table contains 1357 records.
  1. DTS wizard -- The tranfer completed sucessfully, but the data of column with data type money was not correctly transferred.

    eg. value 9700.00 was transferred as 97.00

    I found the leading zero of decimal points were supressed. Is there any solution to proceed?

  2. Tried BCP out in Sybase and tried a bulk insert in MS SQL Server -- it gives an error saying OLE-DB provider error.
  3. I tried to BCP in the Sybase bcp out ASCII file, but failed with the following error:
     CTLIB Message: - L6/08/S5/N3/5/0: ct_connect(): failed
    
It would of immense help if you could provide me a better solution to resolve this.
I can't, because I've always BCP'd the file out of Sybase and BCP'd it into SQL Server. The error message you are getting on the Sybase side indicates that BCP is not installed correctly on Sybase.
This was last published in November 2004

Dig Deeper on SQL Server Database Modeling and Design

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close