How to do it...

  1. Add a new package to the AdventureWorksETL project. Rename it ProcessingExcel.dtsx.
  2. Add a new package-level Excel connection manager. Rename it Excel_Ch07_Orders. Point to your Excel file path and define your Excel version appropriately, as shown in the following screenshot:
  1. Add a Data Flow task to the control flow. Rename it to ProcessExcelOrders. Open the Data Flow tab.
  2. Add an Excel source. Double-click it to open the editor.
  3. Using the Connection Manager tab, define the Excel connection manager. Point to the Excel_Ch07_Orders connection manager you just created. Use the Table or view data access mode. Select Sheet1$ in ...

Get SQL Server 2017 Integration Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial