SQL Server BI Step by step 2

This article supporting source code

Let's start with SSIS and use SSIS to export data from SQL Server. First, open Vs.net 2005, select the Business Intelligence project, then select the Integration Service project in the template and enter the project name:

Once created, we design it in the default package package (for some conceptual, no introduction, please refer to this article, or other tutorials or books. First, add a data flow Task to the control flow, and double-click into the data flow. From the toolbox on the left Select OLE DB source, as you can see, and it's red when you add it. Double-click to set the connection, if there are no links already created, create a new connection, and then set up a direct access to the Produt table, of course, here you can also get the data source through the SQL statement, which You can call a stored procedure, and you can also put the name of the table or view, or the SQL command, directly in the variable by the way the variable is set.

OK, after confirming, found that the red error hint no longer exists. Next, we add a target data source directly, we export the data to Excel data format, so select Excel destination, similarly, double-click the Excel Connection Manager to configure, After you have configured the file name and path (where you choose to display the column name in the first row, so that the data starts at the second row), if the file does not exist, select the new Excel worksheet directly below.