How To Use Import/Export Wizard In SQL Server - SQL Server / TSQL Tutorial Part 104

We have received SourceFile.xlsx file and we have to load that to SQL server Table. We can either create SSIS Package in BIDS or we can use Import/Export Wizard to load this file in SQL Server Table. In this post, we will use Import/Export Wizard.
Fig 1: Excel Source File

Step 1:
Right Click on Database in which your table exists or you want to create it and load Excel data as shown below
Fig 2: Import Data by using Import/Export Wizard in SQL Server Table.

Choose the Data Source:

Choose the data source which you want to use as source, As we are loading data from Excel, Choose Excel file as shown below
Fig 3: Choose Excel Data Source in Import Export Wizard


Choose a Destination:

Choose the destination where you want to load the data from source. In our case we are loading our data to SQL Server Table. Configure as shown below
Fig 4: Choose SQL Server as Destination

Specify a Table Copy or Query:

You can directly choose the table from where do you want to load the data or you can write query if you are using Database as your source. As we are using Excel as source, we will choose Table(Sheet).
Fig 5: Choose Copy data from one or more tables or views 

Select Source Tables and Views:

In this part of Wizard, we have to select the Tables or Views we want to use from source and load data to destination. As we are loading data from Excel, the Excel Tabs are shown. Choose the Sheet (Tab) which do you want to load. Under Destination, it will show you same name like Source. I have changed that to CustomerData. You can choose any name of your Table you want. You can choose multiple sheets or Tables from Source.
Fig 6: Select Source Tables/Views in Import Export Wizard

Column Mappings:

Click on Edit Mappings and then you can map the source columns to destination columns , Also if you need to choose correct Data type, you can change here.
Fig 7: Column Mapping Import Export Wizard


Save and Run Package:

By Default, Run immediately is checked. I have changed the option to Save SSIS Package and provided the location where I want to save the SSIS Package. Also there is no sensitive information that I want to save in Package such as Password so I have selected Do not save sensitive data.
Fig 8: Save SSIS Package to File System

Save SSIS Package:

Provide the name of SSIS Package and File Location as shown below
Fig 10: Provide Name for SSIS Package


Complete the Wizard: 

Summary of all the steps will be shown to you in this step. You can see the source and destination etc.


Fig 11: Summary of Steps

Once you hit Finish button, The Wizard will execute all below steps and finally save the SSIS Package.


Fig 12: Save the SSIS Package to given location

The Package is created on desktop as per my given path.
Fig 13: SSIS Package created by Import/Export Wizard

To execute this package, double click on it and below window will open. If you need to change the name of File or SQL Server, you can go to Connection Managers and change it. In my case, I do not want to make any changes. Press Execute Button

Fig: 14 Execute Package Utility

Once you hit Execute, Package Execute Progress window will appear and you will be able to see the progress of execution of your SSIS Package.
Fig 15: Package Execution Progress.

Import/Export Wizard is a way to quickly load data between different sources and destinations. You can create your SSIS Package quickly by using Import/Export Wizard and then add to SSIS Project and make changes if required.

If we need to export data from SQL Server then we need to Right Click on Database-->Tasks-->Export Data and Import/Export Wizard will start.


Video Demo : How to use Import Export Wizard to load Excel file data to SQL Server Table


19 comments:

  1. You have made some decent points there. I looked on the internet for more information about the issue and found most people will go along with your views on this web site. https://serverbrowse.com/

    ReplyDelete
  2. Most of the time I don’t make comments on websites, but I'd like to say that this article really forced me to do so. Really nice post! https://serverbrowse.com/

    ReplyDelete
  3. popularity is simply rocketing through out the United States and the rest of the world. These bands are shaped into various silly shapes such as musical instruments, animals, alphabets, and many more cool shapes. It's not only the youngsters, but elders too seem to have been snared by this latest fashion. bulk craft glitter

    ReplyDelete
  4. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. us customs data

    ReplyDelete
  5. Thank you for sharing valuable comments for us its very incredible post to whom looking for a particular course if any one who want to learn tally core to advance
    Database Developer Training in Bangalore

    ReplyDelete
  6. Thanks for this. I really like what you've posted here and wish you the best of luck with this blog and thanks for sharing

    Teradata Training in Bangalore

    ReplyDelete
  7. HS code 0102 is Harmonized System Code of Live Bovine Animals. HS code makes your goods documentation easy. It passes the commodities faster through the customs with making the trade a lot smoother and time-saving affair.

    ReplyDelete
  8. Kenya HS Code 0204 is harmonized system code of Meat of sheep or goats, fresh, chilled or frozen. HS Code 0204 is is simple sticker paper which holds over where all impost of the traders and goods data. Without it, the shipping goods is nothing in the import and export trading. "

    ReplyDelete
  9. Thanks for sharing these useful information! Hope that you will continue doing nice article like this.
    Physiotherapy Brampton

    ReplyDelete
  10. I would say, there are three fundamental kinds of SQL Server Certifications.These are for processes, programming arrangements, and different arrangements. I'm intentionally barring related fields, for example, business knowledge or testing and approval to keep this answer clean.

    ReplyDelete
  11. Find out How can I calculate how much mortgage I can afford based on estimates from CMHC and top Canadian banks: RBC, TD, Scotiabank, BMO, and CIBC. Mortgage Affordability Rules in Canada

    ReplyDelete
  12. What is Mortgage Default Insurance and how much will it cost you? See how Mortgage Default Insurance rates vary by down payment levels and paying back periods. Mortgage Default Insurance Calculator

    ReplyDelete
  13. https://banehnovin.com/refrigerator/

    ReplyDelete
  14. Well explained about import export wizard in SQL table! The same concept is used in import export software system

    ReplyDelete
  15. Very interesting concept of import export in SQL. Impexflo import export document management also uses this basic idea.

    ReplyDelete