Load Data form one SQL table to Multiple Excel sheet in SQL 2005

How to load Data form one SQL table to Multiple Excel sheet in SQL 2005 through SS开发者_如何学运维IS

Use BI studio to create a new project.

Create a new data flow task.

From the toolbox drag an OLE DB Source and an excel data flow destination you need.

Choose the OLE DB Source and drag the destination arrow to the excel destination.

Click each datasource and configure the details.

In the control flow you can copy the flow as many times you need and change to excel file destination to another file.