.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS) - Part 2

Posted By:Karthikeyan Anbarasan       Posted Date: February 26, 2011    Points: 100    Category: DataBase    URL: http://www.dotnetspark.com  

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS). In this article we will see how data can be transferred from SQL Server DB to Excel sheet
 

Introduction

In this article we will see how data can be transferred from SQL Server DB to Excel sheet.  Refer to my previous article (Part 1) on the basics of SSIS and steps to create the first SSIS package at the below url

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1


Steps to achieve transforming data from SQL DB to Excel:

Step 1 and Step 2 - Refer to my previous article on the steps at the below url

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1

Step 3: Since our task is to transform the data from SQL Server DB to Excel sheet , add a Data Flow task in the control task tab of package.dtsx as shown in the below screen and double click on the task which will redirect to the Data Flow tab

Step 4: In Data Flow tab add an OLE DB Source task and configure it to the database where we need to perform the transformations and select the table as shown in the below screen. In order to follow the steps on how to configure the SQL DB configuration check my previous article as stated above.

Step 5: Now add the destination source (Excel Data source) as shown in the below screen and make the configuration. To do the configuration first drag the green arrow from SQL data source to the Excel destination tasks and then double click on the excel destination task it will open the below screen for configuration

Step 6: Do the mapping of the columns from both the source and the destination tasks as shown in the below screen

Step 7: Once everything is configured (Source and destination) Press F5 to execute the task and you can find the result at the path where we specified the excel sheet. Check the download section to see the excel sheet which is created with this project.

Conclusion

In this article we have seen how to transform the data from DB to Excel sheet:

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend