SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2004
    Location
    Middleton, Manchester, England, UK
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DTS Access to SQL Server date problem

    I'm trying to convert a table from Access 2003 to SQL Server 2003.

    I'm using the DTS in SQL Server, but I get this error about a date field:

    Insert error, column 15 ('DateComplete', DBTYPE_DBTIMESTAMP), Status 6. Data Overflow. Invalid character value for cast specification.

    Any help would be appreciated.

    Thanks.

    (I tried using the Access Upsizing wizard, but that also failed. And didn't give me a reason why, just said it failed.)

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    from what little information you've provided, i would say that there is probably an invalid date value in the date field
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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