Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Angry Unanswered: Converting text to table with DTS

    I am using DTS to import text to a table. This mostly works except for the 'DateTime' datatype where I always run into either 'Arithmetic overflow' or 'Unable to convert varchar to DateTime format.' I can convert same data without incident in Access.

    Has anyone run into this problem?
    Thanks,
    Bill

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Import the problem dates into a VARCHAR(30) column using DTS. Then mangle them at will using the SQL functions to make them easier to digest!

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    139
    I'm kind of new to SQL...do you mean using functions like CAST and CONVERT in custom DTS packages?
    Thanks,
    Bill

  4. #4
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    whats the format of date in the text file? use IsDate() function in the transformation ActiveX to check for validity of date
    -Rohit

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Pat Phelan
    Import the problem dates into a VARCHAR(30) column using DTS. Then mangle them at will using the SQL functions to make them easier to digest!

    -PatP
    Import everything in to an existing tables as varchar...the perform your audits...

    and learn bcp.......

    Is the file fixed width or delimited?

    Mangle....lol..
    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.

Posting Permissions

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