CODEWITHSUNDEEP
sql-serversql-server-2014
Çağrı Kutlu
Çağrı Kutlu

Reputation: 73

How to select specific columns of tables while exporting with the SQL Server export wizard?

I want to export some tables from a remote server. But there is a problem I can only get specific columns of the tables I don't have permission to other columns.

I set them in edit Mapping by editing SQL but it still tries to get the other columns of tables which are not selected and not in sql

How can I solve it?

Upvotes: 2

Views: 1905

Answers (1)

Giorgi Nakeuri
Giorgi Nakeuri

Reputation: 35780

On Specify Table Copy or Query tab choose Write a query... And write your statement with appropriate columns.

enter image description here

Upvotes: 4

Related Questions