Source type is -1 in Import Export wizard

• IT researcher

  SSCertifiable

  Points: 7567

  More actions

  March 13, 2020 at 6:00 am

  #3733917

  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.

  

  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?

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  March 14, 2020 at 6:10 am

  #3734390

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.