Export from table or view to CSV File:
Following are the process to both export data from view or table and into Excel CSV file with the help of Import Export wizard.
Open SQL Server Management Studio.
Connect to the database engine server. Click on Databases and expand it. Right click on the database that has to be exported and click on Tasks option from the drop-down menu. From the menu, select the Export Data option.
Click on Next to proceed from the Welcome screen.In Choose A Data Source Window, enter the following credentials:
Data Source: SQL Server Native Client 11.0
Server Name: Enter the name of the server
Authentication: Select the appropriate authentication for the connection
Database: Choose the database, which has to be exported.
Click on Next to proceed.
In the Choose a Destination window enter following credentials:
Destination: Select Microsoft Excel from the options.
Excel File Path: Browse the location of the Excel file in which database has to be exported.
Excel Version: Select the Excel version supported on your system.
Click on Next to proceed.
In the Specify Table Copy or Query window, select the Copy data from one or more tables or views.
Click on Next to proceed.
In Select Source Tables and Views window, select the table that you want to export.
In the Review Data Mapping window, you will see different data types mapped between the source and the destination
In the Save and Run Package window, click on Run Immediately option to run the SSIS package immediately. In case, you want to save it click on Save SSIS Package option. Provide the password if required. Click on Next to proceed.
The Complete the Wizard window gives a preview of the choices made by the user. Select Finish option to run the SSIS Package.
Once successful, a complete report of the process is generated. Click on Close to end the process.
