March 13, 2020 at 6:00 am
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?
March 14, 2020 at 6:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy