While using the SSIS data flow, we can perform ETL task that can be used for data migration, data offloading, design and implementation of the data warehouse. In this article, I explain how to export data from an SQL table to excel and text file by using the SSIS data flow task. In this demo, I will perform through the following steps: 1. Create an SSIS package and create ADO.Net connection manager. 2. Create data flow task that has ADO.NET source to populate data from SQL Server. Data will be written to excel file and text file hence configure flat file destination and excel destination. 3. Execute SSIS package and verify that data was written to excel and text files. Create SSIS package and ADO.NET connection For this demo, I used SQL Server Data tools 2015. Firstly, I am creating a new Integration service project named "Export SQL Data": After the creation of an SSIS project, I will create the data flow task. Data flow task will use SQL Server as a source. Excel file and the flat file will be determined as the destination.


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blogtwitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.


This article is related to

SQL Server,database administration,sql server,sql server 2016