How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005

 
In the Select Source Table and Views wizard screen one needs to select the AdventureWorks.HumanResources.Employee Table in the Source and by default Employee will be visible in the Destination. Thereafter click on the Edit Mappings… and make sure all the data types are identical to the one shown in the below image and apply the changes:





In the Save and Execute Package wizard screen there are two options namely Execute Immediately and Save SSIS Package as file system. The developer can make either of the choices and then click on the Finish button to run and end the package configuration.

Conclusion
The SSIS Package will export the data to Employee Sheet of SampleData.xlsx file.

Pages: 1 2




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |