Converting data to SQL Server data with the DTS wizard

Tags:
DTS Import/Export Wizard
DTS Wizard
SQL Server
Sybase
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try to transfer the data to a non-existing table in SQL Server and see how the DTS package creates this column in the new table (which datatype).
If the data is then transferred properly, use this “temporary” table to hold the data and insert the data to the real table using an insert statement, in SQL Server , after the transfer (converting that column if required).

Please let me know how it went.

Thanks,
Michelle.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    I would assume this has something to do with how the money datatype is displayed on the Sybase system by default. According to what I just read on Sybases Website it is displayed with only two digits after the decimal by default (four are stored). DTS may be doing something funky with this. Try putting the value into a table with the numeric(18,4) datatype instead and see how that works. I would also be interested in knowning what data types DTS uses when it creates the table automatically.
    66,085 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following