I need to convert my Sybase data to SQL Server data. I tried using several methods for a single table that contains 1357 records.
When I used the DTS wizard, the tranfer completed sucessfully but the data in the column with data type "money" was not correctly transferred. For an example, the value 9700.00 was transferred as 97.00. I found that the leading zero of decimal points was supressed. Is there any solution to proceed?
February 27, 2009 3:41 PM
February 27, 2009 7:11 PM