The SQL Server Import and export wizard provides a graphical user interface onto a SQL Server Integration Services (SSIS) package. Once created the package can be automated, to run on a schedule. It can be further configured and modified by using SQL Server Data Tools (SSDT)
To begin, open the Import and export wizard, right-click a database and select the Tasks sub-menu -> Export data command:

- Connect to a source database via the Choose a data source step.Permissions: You will need the following permissions to for the source data source/instance
- read data from the database or file
- Insert permission on the msdb database to save the SSIS package
- Connect to a destination SQL Server database in the Choose a destination step.Permissions: The following permissions are required for the destination instance:
- write data to the database or file
- permissions to create a database
- if necessary, permission to create table
- Choose the Copy data from one or more tables or views option, In the Specify table copy or query step:https://isqlplus.com/sql-server/
- In the Select source tables and views step, choose the table(s) for which you want to export data from:
- In the Save and run package step, choose the Run immediately option:
- in the Complete the wizard step, Click Finish
- Once completed, the following dialog will be displayed:
Troubleshooting: The SQL Server import and export wizard will not distinguish identity columns from any other column type. This will lead to errors when inserting data into such columns



Troubleshooting: The SQL Server import and export wizard also doesn’t process tables based on dependency order. An example might be loading a table, with a foreign key (the child), before the referencing table the parent, causing a foreign key constraint failure
Also See: