Source type is -1 in Import Export wizard

Researcher · March 13, 2020, 4:45am

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 Data type of source coulmn chnaged from Time to -1 and the type mismatch error occurs.

If i choose "Copy From data one or more Tables Or Views" table copies successfully without an error and the data type remains unchanged.
How to solve the error with choosing "Write a query to specify data transfer" option?

yosiasz · March 13, 2020, 5:37am

What data type is val3 in source table?

Researcher · March 13, 2020, 5:52am

Source table column Val3 datatype is time(0).

yosiasz · March 13, 2020, 10:15am

And what database product is the source? Microsoft SQL, mysql, poatgres

Researcher · March 16, 2020, 7:06am

Microsoft SQL

jeffw8713 · March 16, 2020, 4:57pm

What is the query you are trying to run? SQL Server cannot determine the columns data type based on the data in that column.

Researcher · March 17, 2020, 4:36am

Select * from Table_1

jeffw8713 · March 17, 2020, 4:41pm

Okay - what is the definition of Table_1? Is this actually a view?

yosiasz · March 17, 2020, 5:28pm

post here the DDL of Table_1

Create table Table_1 (
--here list the columns
)