- 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?
- Tried BCP out in Sybase and tried a bulk insert in MS SQL Server -- it gives an error saying OLE-DB provider error.
- 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
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.