Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Unanswered: DirectCopyXform error when using DTS

    I am trying to import data and I receive an error that it failed to copy one table. The error says conversion error: Destination does not allow NULL on column pair 2(source column 'DateUsed' (DBYTYPE_DATE), destination column 'DateUsed'(DBTYPE_DBTIMESTAMP)). I have tried to change the data type for DateUsed to several different types in Access. I am not sure why it is not accepting it. If anyone has any ideas, I would appreciate it. Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well, for starters, what's the actual SOurce? SQL Server?

    What's the Destination? MS Access?

    Why not DTS The Source to the Destination and let DTS create an object for you, and see what it defines.

    Then comapre the 2.
    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
    Sep 2004
    Posts
    5
    The source is actually Access and the destination is SQL server. I used DTS to import data from an Access db and it failed to copy one table because of this date error.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    OK.

    What I suggests still stands.

    Use DTS and let it create a sql server table and find out what it creates.
    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
  •