Zack
asked on
SQL Server Import/Error Wizard error
Heyas,
I am getting the following error, please see the attached picture 'errors 1'.
I don't understand why this is occurring the column details look to be the same.
The last picture is a preview of the SQL query being the Column Names are the same.
Any assistance is appreciated.
Thank you.
Errors-1.PNG
Column-Details.PNG
Preview-of-SQL-Query-being-run---Col.PNG
I am getting the following error, please see the attached picture 'errors 1'.
I don't understand why this is occurring the column details look to be the same.
The last picture is a preview of the SQL query being the Column Names are the same.
Any assistance is appreciated.
Thank you.
Errors-1.PNG
Column-Details.PNG
Preview-of-SQL-Query-being-run---Col.PNG
ASKER
Hi Hua,
Where is that option?
Thank you.
Where is that option?
Thank you.
ASKER
Hi HuaMinChen,
How does that relate to my question, I don't understand. I am trying to export data from sql query into a database table.
Thank you.
How does that relate to my question, I don't understand. I am trying to export data from sql query into a database table.
Thank you.
Hi,
Are you copying data from one schema into another schema?
Are you copying data from one schema into another schema?
ASKER
Hi HuaMinChen,
Yes the query I running gets data from one database and I am inserting the query results into the table of another database.
Thank you.
Yes the query I running gets data from one database and I am inserting the query results into the table of another database.
Thank you.
Zack, is the source a SQL Server table or a .txt/.csv file?
If it's a SQL table please post here the table schema.
Another thing that you can do is to double click in the column that has the error to see if more info has been provided.
If it's a SQL table please post here the table schema.
Another thing that you can do is to double click in the column that has the error to see if more info has been provided.
Yes the query I running gets data from one database and I am inserting the query results into the table of another database.
Hi,
YOu can do these
1. create a temp schema
2. copy whole table into that schema
3. backup schema
4. restore schema file on one other server
5. copy the table from temp schema into other schema
ASKER
Hi Vitor/HuaminChen,
The source is SQL query which calls multiple tables in a database. I'll post the details of the query and schema details tomorrow.
Thank you.
The source is SQL query which calls multiple tables in a database. I'll post the details of the query and schema details tomorrow.
Thank you.
ASKER
Hi Vitor/HuaminChen,
Attached are some of the details, let me know what schema details I should provide.
Thank yuo.
Source---SQL-Query.txt
Error-2.PNG
Attached are some of the details, let me know what schema details I should provide.
Thank yuo.
Source---SQL-Query.txt
Error-2.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you vitor spot on I will have to get another version SQL management studio.
Did you choose 'Overwrite' option to overwrite the relevant Schema?