Results 1 to 5 of 5

Thread: import data from MS Access databases to SQL Server 2000 using the DTS Import/Export

  1. #1
    Join Date
    Oct 2006
    Posts
    19

    import data from MS Access databases to SQL Server 2000 using the DTS Import/Export

    I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors.

    Error at Destination for Row number 1. Errors encountered so far in this task: 1.
    Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
    Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
    Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
    Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
    Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.

    Could you please look into this and guide me
    Thanks in advance
    venkatesh
    imtesh@gmail.com

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What's source and target data types of those columns? What are values in those columns?

  3. #3
    Join Date
    Oct 2006
    Posts
    19

    reply...

    Both the source and destinations data types are Date/Time.
    Sql server cannot able to accept this data type fromt MS-Access. I think Sql server 2000 service pack 4 is the best solution for this issue.. Whats your opinion.. Could you please guide me in this issue..
    Thanks
    Venkatesh
    imtesh@gmail.com

  4. #4
    Join Date
    Sep 2006
    Location
    Chennai,India
    Posts
    15
    Change the
    Destination Datatype of (VRptTime, ViewMentalTime, ViewAppTime,Time) SmallDateTime
    in to DateTime


    1 ) In the Select Source Dialog Box,
    Select the Transform Button.


    2) Then You get Column Mapping & Transfermations Dialog Box.

    3) In that Dialog Box - Column Mapping Tab

    If u select [Create Destination Table] option and Drop and Recreate Option..

    Then Only you Change the Destination Datatype in Type Column.
    Last edited by anbeshivam; 11-27-2006 at 01:15 AM.
    Regards,
    Shiva

  5. #5
    Join Date
    Oct 2006
    Posts
    19

    Thanks..

    yeah thanks i fixed...

Posting Permissions

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