Post reply

Source type is -1 in Import Export wizard

  • March 13, 2020 at 5:58 am

    #3733914

    I am trying to import/export data from one database in a server to a new table in a different database,

    using SQL Server import and Export Wizard. (SQL Server Management Studio 2008)

    I choose "Write a query to specify data transfer" option.

    While Importing/Exporting the source table column val3 Data type changed from "time to -1 "  and unknown column type conversion error occurs.

    sql

    If i choose "Copy From data one or more Tables Or Views" table copies successfully without error and the data

    type remains unchanged.

    How to solve the error with choosing "Write a query to specify data transfer" option?

  • March 13, 2020 at 9:09 am

    #3733945

    I choose "Write a query to specify data transfer" option

    type your query please

    • This reply was modified 4 years, 8 months ago by  handkot.

    I Have Nine Lives You Have One Only
    THINK!

  • March 14, 2020 at 4:38 am

    #3734378

    I used this Query.

    Select * from Table_1

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply