O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required