SQL Server Integration Services (SSIS) – Part 3 – Export Data using Wizard

Karthikanbarasan
Posted by in Sql Server category on for Intermediate level | Points: 250 | Views : 13356 red flag
Rating: 5 out of 5  
 2 vote(s)

This is part 3 of the series of article on SSIS. In this article we shall see how to export the data from SQL Server using the wizard.


 Download source code for SQL Server Integration Services (SSIS) – Part 3 – Export Data using Wizard

Introduction

In this article we will see on how to export the data from SQL server using the wizard which is provide with the SSMS (SQL server Management Studio). Using SSMS we can perform many tasks like copying data from one server to the other or from one data source to the other in variety of formats. Here our task is to do a transform of data from SQL server to Excel using the Wizard. You can look into Part 1 and Part 2 of my SSIS articles at the below urls

Part 1

http://www.dotnetfunda.com/articles/article1164-sql-server-integration-services-ssis-part-1-basics-of-ssis-and-creati-.aspx

Part 2

http://www.dotnetfunda.com/articles/article1189-sql-server-integration-services-ssis-part-2-transforming-sql-data-to-.aspx


Steps


Step 1: Go to Programs à Microsoft SQL Server 2005 à SQL Server Management Studio and connect to the list of server db’s which we have to perform the task as shown in the below screen


Step 2:  Once you locate the Database where we need to perform the transformation then Right click on the database and go to Tasks then select Export Data. It will open a welcome screen Click Next and move to the Datasource tab.


Step 3: Choose a Datasource tab helps to select the source of the data transformation selected at the initial stage itself.  Once the required information’s are selected click on next and it will ensure to select the destination source.


Step 4: Now the destination data source window will open, here we need to specify the destination (In our example excel sheet) so select Microsoft Excel from the drop down and provide the path on where it should save the excel sheet


Step 5: Now we need to specify from which table we need to transform the data or we can write our own query based on which the data need to be transformed. Here we can select the table so mark that option and click on next as shown in the below screen


Step 6: Once we click on next button it will show the list of tables to be selected. Select the table which we need to do the transformation and click on preview to double check the output as shown in the below screen and click on Next button.


Step 7: Once we are done with the source and destination it will ask to save and execute the package. Click Next and Finish to complete the transformation as shown in the below screen.


Step 8: Once we are done it will show the process on the how the task is carried over and shows the final result on the tasks completed as shown in the below screen. If it’s completed without any error it will create the excel sheet at the folder where we specified in the destination tab




Conclusion

This article we have seen on how to use the export wizard to make a transformation and to execute the package using the wizard. Sample project is included along with the final result (excel sheet).

Page copy protected against web site content infringement by Copyscape

About the Author

Karthikanbarasan
Full Name: Karthikeyan Anbarasan
Member Level: Silver
Member Status: Member,Moderator,Microsoft_MVP,MVP
Member Since: 1/2/2011 3:00:14 AM
Country: India
Thanks Karthik www.f5Debug.net
www.f5Debug.net
www.f5Debug.net Around 5 years of experience in Microsoft technologies like ASP.Net, VB.Net, C#.net, SQL server, Biztalk Server, WCF, WPF, SSIS, SSRS, SSAS, AJAX and working as Senior Analyst in a US based MNC.

Login to vote for this post.

Comments or Responses

Posted by: manikandanpszsl-20650 on: 2/7/2013 | Points: 25
nice article... easily understanding the process of export.

Login to post response

Comment using Facebook(Author doesn't get notification)