Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: DTS and decimal issue

    I am importing a table from our ERP system using a DTS. THe table imports fine. The only issue that I am having is that a decimal field in our ERP system can be for example 105.1275, but when it gets inported to sql the number is 105.1270.

    What could possibly be the issue and sollution for this. All help is appreciated.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Ummm... what's the source platform of the data and the destination platform?

    That'll learn you for using DT...uh...I can't say it....

    Did you look at the transformation? Waht's the DDL of the source and destination look like?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63

    check precision

    Check that the precision/length settings for the destination field is correct.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •