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. With the solution opened, expand the ETL.Staging SSIS project. Select the EP_Staging.dtsx package and open it. Navigate to the Event Handler tab and select the OnPreExecute event handler from the drop-down list, as shown in the following screenshot:
  1. As shown in the following screenshot, click the hyperlink to create the OnPreExecute event handler:
  1. If you look at the Variable pane, you'll notice that there are is a variable in that package that is called LoadExecutionId. This variable will hold the value returned by the ...

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