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?