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. Open SSMS if not already open and go to the SSIS catalog node. Expand it and navigate to the EP_Staging entry-point package. Right-click on it and select Execute from the menu that appears.
  2. The Execute Package window opens. Click on the ellipsis button (...) to set all parameter values, and accept the default that is used in the project.
  3. As shown in the following screenshot, click on script and select New Query Editor Window:
  1. The execution script is created into a New Query Editor Window. Click on Cancel to close the Execute Package window.
  2. Going back to SSMS, you can see that all execution steps have been scripted.

 

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