Results 1 to 2 of 2

Thread: DTS load

  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: DTS load

    New to SQL Server

    load a txt file to SQL

    there is a field, data type is numeric (13,6).
    But in the file, it is like this: 9999999999999

    How do I add the decimal points to make it: 9999999.999999????

    Thanks a lot

  2. #2
    Join Date
    Feb 2004
    Posts
    4

    Re: DTS load

    Originally posted by qingbo
    New to SQL Server

    load a txt file to SQL

    there is a field, data type is numeric (13,6).
    But in the file, it is like this: 9999999999999

    How do I add the decimal points to make it: 9999999.999999????

    Thanks a lot
    Add an Execute SQL Task object to the package and insert code something similar to this:

    UPDATE tablename
    SET ColumnName = ColumnName / 1000000.00

    Where ColumnName is the numeric(13, 6) column defined in the table.

    Hope this helps.

Posting Permissions

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