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.
The SSIS Package will export the data to Employee Sheet of SampleData.xlsx file.
Pages: 1 2