What is SQL Server Import / Export wizard for SSIS?

It helps to DBA and developer to data movement from a source to any targeted source.

Steps to run a wizard in SQL Server

1.       Select a database in Microsoft SQL Server Management Studio.

2.       Right click on database, Go to Tasks and select Import / Export wizard.

3.        New window will appear

4.       Click Next; it will take to another page for the source selection

5.       Select the data source; by default it is SQL Native client if your source is different your can chose data source as access, excel, txt file or any other database provider.

6.       If you have selected the data source SQL Native client then need to provide the server and credential details and chose database from where your want to transfer data.

7.       If you have selected any other data source like access, excel or txt file then browser the file from the physical path. And here you need to follow some more steps I will explain in my next post.

8.       Click next; It will take to another page for the destination selection. This section is as same as the data source.

9.       Click next ; It will take to summary page

10.   Click finish